Command to extract data

Post Reply
User avatar
Surya47
Nouveau
Nouveau
Posts: 6
Joined: 16 Jan 2014 12:00

Command to extract data

Post by Surya47 » 17 Jan 2014 2:18

Is there any command to extract job list for a particular day and time.

eg : I need a list of jobs that run on 17th 2PM to 5PM.

User avatar
anirudhrh
Nouveau
Nouveau
Posts: 48
Joined: 21 Sep 2013 12:00

Post by anirudhrh » 18 Jan 2014 7:04

You can use the table cmr_ajf ( if the jobs are in active network )

u can use a query like

select jobname,startrun from cmr_ajf where start run between '01/17/2014 14:00:00' and '01/17/2014 17:00:00';
Anirudh

Post Reply