Need a Scheduler report to list the job name and the frequency of job run

Products

• Scheduler Job Management

Issue/Introduction

How to produce a Scheduler report to display job name, and the frequency of the job run such as Daily, Weekly, Monthly, Quarterly, Semi Annual, Annual, or on Request

Environment

Release : 11.0

Component= Scheduler Job Management MVS

Resolution

Here are the options if job history information is needed: 

1.  Run CAJUTIL0 command 'REPORT JOBHIST NAME=*,DETAIL=NO' 

2. Sample SQL job to return all jobs that have completed successfully (SCHD_EVENT_TYPE=17).  Scheduler data set CAIMAC(HISTTYPE) contains the list of values for SCHD_EVENT_TYPE.  

//SQLEXEC EXEC PGM=DBSQLPR,REGION=2M                                
//STEPLIB  DD DISP=SHR,DSN=your_datacom_cuslib          
//         DD DISP=SHR,DSN=your_datacom_loadlib        
//SYSPRINT  DD SYSOUT=*                                             
//STDOUT    DD SYSOUT=*                                             
//OPTIONS   DD *                                                    
PRTWIDTH=255                                                        
INPUTWIDTH=70                                                       
ROWLIMIT=10000000                                                   
NOTYPE                                                              
//SYSIN     DD *                                                    
 SELECT                                                             
  SCHD_JOBNAME,                                                     
  SCHD_HISTORY_TIME,                                                
  SCHD_EVENT_TYPE                                                   
  FROM SYSUSR.SCHD_HISTDETAIL_CH430                                 
  WHERE SCHD_INSTANCE = 'SCHD'                                      
   AND SCHD_EVENT_TYPE = 17                                         
  ORDER BY SCHD_JOBNAME                                             
  ;         

Here are the options if job definition is needed:

1. Run CAJUTIL0 command 'UNLOAD SCHEDULE NAME=*' to dump all the jobs definitions from all the schedules to a sequential file.  The run frequency is in the criteria record (JCR) of each job. 

Reference: Using the Database Unload Command for Scheduler

2. Run CAJUTIL0 command 'LIST JOB NAME=*' to produce a report listing of all job definitions.  The run frequency is in the Job Base Record, under 'CRITERIA'.