Obtain Average Runtime using script or SQL Query

JoseJolly · Post by **JoseJolly** » 28 Apr 2010 4:25

Does anyone know how to obtain the average runtime of jobs from control m using an SQL query or a script.

Walty · Post by **Walty** » 28 Apr 2010 8:57

Hi,

look this post

JoseJolly · Post by **JoseJolly** » 02 May 2010 7:39

Do you know which table/values to query for knowing if a job is currently in running status or not ?

Walty · Post by **Walty** » 03 May 2010 9:35

Hi,

Table is CMR_AJF
All the valid states used by CONTROL-M/Server

STATE:
0 Wait for Scheduling Criteria to be evaluated
1 Wait for Confirmation from user
2 Submitted to Agent
3 Not submitted to Agent
4 Executing
5 Ended
6 Analyzed Post Processing Steps
7 Disappeared
8 Post Processed
9 Not Found
A Waiting to Rerun
B Waiting for From Time
C Wait for In Condition
D Wait for Resource
E Wait for Submission
F Not used by CONTROL-M/Server
G Retry Submission to Agent
H Wait for Group Scheduling
I Failed To Submit
J Job waiting for Odate
K Job is past its Odate
Z Agent Status is Unknown

STATUS:
Y means that the job has completed successfully.
N means that he has not completed or it has completed unsuccessfully.

HOLDFLAG:
N not on hold
Y on hold
D Job was deleted.

See section Main/Trucs et Astuces / Tricks and Easy ways/Database Posters on this site http://www.scheduler-usage.com/modules. ... =Downloads