ESP Program With PARM=SAR

[derrick.massey.1]

Hello,

I create a report using the ESP program with the PARM=SAR to show jobs defined to ESP: 

*********************************************************************************************************8******

//STEP0030 EXEC ESP,PARM='SAR'                  

//SYSPRINT DD  SYSOUT=*                        

//SYSIN    DD  *                                

MAPGEN DATASET('TESTAPPL.ESP.MAPGEN') EVENT(-.-)

//STEP0040 EXEC PGM=ESP,PARM='SUBSYS(ESP)'                        

//SYSPRINT DD  DSN=TESTAPPL.ESP.MAPGEN.PRINT,                      

//             DISP=(,CATLG,DELETE),                              

//             UNIT=SYSDA,                                        

//             SPACE=(CYL,(50,10),RLSE),                          

//             DCB=(HRS1.MODLDSCB,RECFM=FB,LRECL=133,BLKSIZE=26600)

//SYSIN    DD  *                                                  

JOBMAP DSN('TESTAPPL.ESP.MAPGEN') -                                

NODISPLAY(CLASS) 

**********************************************************************************************

These steps produce the report below:

JOBNAME      SCHEDULE     TYPE                        ACTION               FREQUENCY    
TESTJOB1      TESTAPP1        JOB                          SCHEDULED:     WORKDAYS
TESTJOB1      TESTAPP2       JOB                          SCHEDULED:     WORKDAYS
TESTJOB2     TESTAPP2       TASK                        SCHEDULED:     DAILY  
TESTJOB3     TESTAPP3        LINK                        SCHEDULED:     WORKDAYS
TESTJOB4     TESTAPP4       REQUEST                SCHEDULED:     WORKDAYS
TESTJOB5     TESTAPP5       MANUAL                 SCHEDULED:     WORKDAYS   

***********************************************************************************************************************

My question: Are there control statements to show only records in the JOB & REQUEST 'TYPE' column?

                      Also, is there a way to only show a job one time? (No Duplicate Job names)

************************************************************************************************************************

This is what the above report would look like:

JOBNAME      SCHEDULE     TYPE                        ACTION              FREQUENCY    
TESTJOB1      TESTAPP1        JOB                        SCHEDULED:       WORKDAYS 
TESTJOB4     TESTAPP4       REQUEST               SCHEDULED:       WORKDAYS

*************************************************************************************************************************

------------------------------
Derrick
------------------------------

[Lucy Zhang]

Hi Derrick,

Firstly the two entries for JOB TESTJOB1 are for different SCHEDULEs, so they are not duplicate.

Secondly there is no control statement to satisfy your requirement. But you can utilize the CSV option for JOBMAP, this will generate the entries that can be exported to the excel sheet where you can filter the output.

See more above CSV option on the doc link below:
https://techdocs.broadcom.com/us/en/ca-mainframe-software/automation/ca-workload-automation-esp-edition/12-0/reference/commands/jobmap-command-produce-job-activity-report.html

Hope this helps,

Lucy