Report on ESP jobs between a certain time

Products

• ESP Workload Automation

Issue/Introduction

Trying to use the below Criteria statement to get all jobs that started after 14:00 and Ended before 17:00:
CRITERIA EXECST GE 14:00 AND ENDTT LT 17:00

But got:
ESP2474I NO RECORDS FOUND TO MATCH SPECIFIED CRITERIA.

 

Environment

Release: ALL

Component: ESP WORKLOAD AUTOMATION

Cause

Using EXECST as a comparison does not produce any valid records.

Resolution

Use EXECSTTOD and ENDTTOD as reporting CRITERIA to produce a report which reports on jobs between a certain time frame.

Example:

FROM 14:00 FEB 17,2021 TO 17:00 FEB 19,2021
CRITERIA EXECSTTOD GE 14:00 AND ENDTTOD LT 17:00
DISPLAY JOBNAME, LONGNAME,EXECQT, EXECSDATE, EXECST, ENDT,  EXECSTTOD, ENDTTOD,
          CPUTIME, AGENT, APPL, SUBAPPL, APPLGEN
SORT EXECQT D                                                  
ENDR