Scheduler Usage

Hi All,
I want write a script that should report me all the jobs that are running over 12 hours. I started it using "ctmpsm -listall |grep executing"
but it lists all the jobs that are currently executing. How can I filter the list of jobs running over 12 hours out of this list ?

Please help. Thanks in advance..

Hi,

You can try the below query in a script

select ORDERNO,APPLGROUP,JOBNAME,STATUS,STATE,STARTRUN,ENDRUN,ORDER_TIME from CMR_AJF where STARTRUN < 'yyyymmddhhmmss' and STATE = '4'

This should help.

what kind of database are you using?

Thats cool.

I don't have db access. I did that using "ctmpsm" utility.

ctmpsm -listall TIME |grep "executing"

It worked