Sample SQL to list CA 7 jobs that have 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 that have dataset predecessors.

Resolution

SQL statements:

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