How to Report on jobs between a certain time.

book

Article ID: 210204

calendar_today

Updated On:

Products

CA Workload Automation ESP Edition

Issue/Introduction

I am trying to use the below Criteria statement to get all jobs that started after 14:00 and Ended before 17:00, but I get: ESP2474I NO RECORDS FOUND TO MATCH SPECIFIED CRITERIA.

 

Cause

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

Environment

Release : 11.4

Component : CA ESP WORKLOAD AUTOMATION

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