Need to list ONLY the jobs that have USER-Requirements?
Release : 12.0, 12.1
Component : CA-7
Below is sample SQL to list all job from database that have user requirements: You will need to modify the STEPLIB and LOGICALDATABASE
//STEP1 EXEC PGM=DBSQLPR //STEPLIB DD DISP=SHR,DSN=your.CUSLIB // DD DISP=SHR,DSN=your.CAAXLOAD //SYSPRINT DD SYSOUT=* //STDOUT DD SYSOUT=* //OPTIONS DD * PRTWIDTH=255 INPUTWIDTH=70 ROWLIMIT=5000 AUTHID=MFWA NOTYPE //SYSIN DD * SELECT SUCC_OBJECT, PRED_OBJECT FROM CA7_REQUIREMENT WHERE DB = 'yourlogicaldb' AND PRED_TYPE = 'USER' ;