Hi,
I never coded script for ESP scheduler. With help of google I have done coding and achieved 70 percent of my desired result. For completion I am not able to find any help from google. Someone please help me out.
I have to generate monthly report for different carriers. Carriers are identified using JOBNAMES. Instead of PL/I program I opted ESP script. Planned to schedule the new JOB to run on First day of every month.
I have coded the JCL as below
//TSID2510 EXEC PGM=ESP,REGION=4M
//*
//SYSIN DD DSN=E861559.SC239212.TEST.CNTLLIB(TSID2513),DISP=SHR
//SYSPRINT DD DSN=E861559.TSID025.A01,DISP=OLD
//SYSUDUMP DD SYSOUT=*
In TSID2513 member in control librarey I have coded as below
REPORT
HISTFILE HIST1
FROM 01AM APRIL 1 2019 TO 11PM APRIL 30 2019
CRITERIA JOBNAME EQ 'SID028' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'SID024A' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'SID024C' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'SID026' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'SID033' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'SID045' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'ABA51A' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'ABA5TP' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'ABA005U' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'ABA5DB' AND CMPC EQ 0
DISPLAY JOBNAME 25 'SYSTEM NAME',EXECSDATE 20 'FTP DATE',
ENDT 15 'FTP TIME',CMPC 15 'RETURN' 'CODE'
SORT JOBNAME EXECSDATE
BREAK JOBNAME 6 SPACE 1
ENDR
I am getting the result but the output is containg the control cards as well as below.
1ESP VER 11.4 BATCH INTERFACE 04.49.54 THURSDAY MAY
0
REPORT
HISTFILE HIST1
FROM 01AM APRIL 1 2019 TO 11PM APRIL 30 2019
CRITERIA JOBNAME EQ 'SID028' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'SID024A' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'SID024C' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'SID026' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'SID033' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'SID045' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'ABA51A' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'ABA5TP' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'ABA005U' AND CMPC EQ 0
CRITERIA JOBNAME EQ 'ABA5DB' AND CMPC EQ 0
DISPLAY JOBNAME 25 'SYSTEM NAME',EXECSDATE 20 'FTP DATE',
ENDT 15 'FTP TIME',CMPC 15 'RETURN' 'CODE'
SORT JOBNAME EXECSDATE
BREAK JOBNAME 6 SPACE 1
ENDR
1ESP VER 11.4 BATCH INTERFACE 04.49.54 THURSDAY MAY
0
SYSTEM NAME FTP DATE FTP TIME
ABA005U TUE 2APR19 20.18.38
ABA005U TUE 2APR19 04.47.24
ABA005U WED 3APR19 22.18.53
ABA005U THU 4APR19 22.40.25
ABA005U FRI 5APR19 20.06.12
Is there any way to strip the top part and contain only report part as below
SYSTEM NAME FTP DATE FTP TIME
ABA005U TUE 2APR19 20.18.38
ABA005U TUE 2APR19 04.47.24
ABA005U WED 3APR19 22.18.53
ABA005U THU 4APR19 22.40.25
ABA005U FRI 5APR19 20.06.12.
For this do I need to code anything else in jcl or in ESP report script. Please advise and help.
Thanks & Regards