Sample SQL to list CA 7 jobs with dataset requirements

Products

• CA 7 Workload Automation

Issue/Introduction

You can use the SQL to extract data from the CA 7 database. This sample SQL control statements will list all jobs and its dataset requirements. It will exclude jobs that are marked MAINT=Y.

 

Environment

Release : 12.0, 12.1

Component : CA 7

Resolution

SELECT SUBSTR(SUCC_OBJECT,1,15) AS JOBNAME,                        
       PRED_OBJECT AS DATASET_REQUIREMENT FROM CA7_REQUIREMENT R,
       CA7_JOB J                                                  
WHERE R.DB = 'yourlogicaldb' AND                                    
      PRED_TYPE = 'DSN'          AND                              
      PRED_PERMANENT = 'N'       AND                              
      J.DB  = R.DB               AND                              
      J.JOB = R.SUCC_OBJECT      AND                              
      IGNORE_RQMT = 'N'                                          
ORDER BY JOBNAME ;