How to calculate average execution time of a job when 'Estimate End Time' and 'Propogate Dueout Time' options were checked in the Application properties

Products

• DSERIES- SERVER
• CA Workload Automation DE - Scheduler (dSeries)
• CA Workload Automation DE

Issue/Introduction

SQL statement to calculate the average execution time (AET) of a job in an application.

 

Environment

 Component: Workload Automation DE

Resolution

To calculate the average execution time (AET) of job TEST_JOB in application TEST_APPLICATION, query the DE database using the SQL statement;

SELECT START_DATE_TIME, END_DATE_TIME FROM (SELECT B.START_DATE_TIME,B.END_DATE_TIME FROM ESP_APPLICATION A, ESP_GENERIC_JOB B WHERE A.APPL_NAME ='TEST_APPLICATION' AND A.APPL_ID = B.APPL_ID AND B.JOB_NAME ='TEST_JOB' AND B.JOB_QUALIFIER ='' AND B.STATE = 'COMPLETE' ORDER BY B.END_DATE_TIME DESC) WHERE ROWNUM <=10;

Substitute the required fields where necessary; APPL_NAME, JOB_NAME, and JOB_QUALIFIER.

Also, you can list average execution time (AET) data by issuing the LISTAETDATA command.

 

Additional Information

listaetdata Command—List Average Execution Time Data