Page 1 of 1

Command to extract data

Posted: 17 Jan 2014 2:18
by Surya47
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.

Posted: 18 Jan 2014 7:04
by anirudhrh
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';