CA 7 SQL Report Request

book

Article ID: 198458

calendar_today

Updated On:

Products

CA Workload Automation CA 7 Edition Automic Automation Intelligence CA Unicenter Job Management Option CA Workload Automation iDash

Issue/Introduction

Is it possible to request SQL to report all jobs with Data Set Predecessors with PERM=N. The report should only have two columns, Job Name and Data Set (where PERM=N)?

Environment

Release : 12.1

Component : CA-7

Resolution

Run your PGM=DBSQLPR with the following control cards in the sysin:

 

SELECT SUBSTR(SUCC_OBJECT,1,8) AS JOB, DATASET      
       FROM CA7_REQUIREMENT R, CA7_DATASET D        
WHERE  R.DB = 'yourlogicaldb'                        
AND    PRED_TYPE = 'DSN'                            
AND    D.DB = R.DB                                  
AND    D.DATASET = R.PRED_OBJECT                    
AND DSN_PERMANENT = 'Y' ;