How to Extract from ESP Report Writer for Last Run

book

Article ID: 196031

calendar_today

Updated On:

Products

CA Workload Automation ESP Edition

Issue/Introduction

I need to create a report for mainframe batch jobs and the last run for each job.

I have the following, 
REPORT                                                              
HISTFILE HIST1                                                      
INPUT FILE(GDGHIST)                                                 
SETWIDTH 80                                                         
CRITERIA JOBNAME EQ 'VBW-' AND WOBTYPE EQ '  ' AND TASK EQ 'NO' ;   
FROM JUN 01, 2020 00:00:01 TO JUN 30, 2020 07:59:59                 
DATEFORM DAY(NO)                                                    
DISPLAY FULLNAME 15,        -                                       
        JOBNO,              -                                       
        CCFAIL,             -                                       
        CMPC,               -                                       
        EXECSDATE,          -                                       
        EXECST,             -                                       
        ENDDATE,            -                                       
        ENDT                                                        
SORT EXECSDATE,EXECST,ENDDATE,ENDT                                  
ENDR                                                                

What can I add to get just the last run for each job.  There are about 1,000,000 jobs that need to be reduced to just the last occurrance for each job.

Environment

Release : 11.4 & 12.0

Component : CA ESP WORKLOAD AUTOMATION

Resolution

ESP history report feature doesn't have a way to display only the last run of the same job.

One way around:
Add FULLNAME to be the first SORT field, and BREAK to make is easier to locate. Like below:
SORT FULLNAME,EXECSDATE,EXECST,ENDDATE,ENDT
BREAK FULLNAME 64 SPACE 1

Then in the report output, entries will be sorted by JOB's full name, and there is a blank line for every JOB.

Note: Client decides to collect the data to put them into DB2 database or EXCEL file.