Sample SQL to list CA 7 jobs that are dataset triggered

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 are dataset triggered.

Resolution

SQL statements:

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