Identifying jobs that have a specific dataset requirement

Products

• CA 7 Workload Automation

Issue/Introduction

 Is there a CA 7 command and or SQL query to list  jobs which have a specific dataset as the requirement.  Will this command work on a wild char as part of the dataset name?  

Resolution

The closest command is LCTLG,DSN=AUTO.  however, it will list all dataset names and the triggered jobs.  There is not a way to pull the information using a command for a specific dataset.  You can use  SQL to  list the jobs that have a specific dataset as requirement . The sample SQL job is found in the AL2SQL member in the CAL2JCL library.  Use the percent sign (%) as a wildcard character in your SQL syntax.   

Run  SQL with the following control statements to list jobs with a specific dataset requirement:

sql

 

SELECT SUBSTR(SUCC_OBJECT,1,8) AS JOB,                         
PRED_OBJECT AS PREDECESSOR_DATASET FROM CA7_REQUIREMENT       
WHERE DB = 'yourlogicaldb' AND                                     
PRED_TYPE = 'DSN' AND                                         
PRED_OBJECT LIKE 'AFOPER.TRIG.DSPENDD%'                                   
ORDER BY JOB ;