SQL command to display all the OWNER ID's that are defined to jobs in CA7.
Release : 12.1
Component : CA 7
//LISTDB EXEC PGM=DBSQLPR
//STEPLIB DD DISP=SHR,DSN=YOUR.DATACOM.CUSLIB
// DD DISP=SHR,DSN=YOUR.DATACOM.CAAXLOAD
//SYSPRINT DD SYSOUT=*
//SNAPPER DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//OPTIONS DD *
PRTWIDTH=255
INPUTWIDTH=70
ROWLIMIT=5000
AUTHID=MFWA
NOTYPE
//SYSIN DD *
SELECT JOB, OWNER FROM CA7_JOB
WHERE DB = 'YOUR DATABASE NAME' AND
OWNER <> ' ' ;
SELECT JOB FROM CA7_JOB
WHERE DB = 'LOGICAL DATABASE' AND
OWNER = ' ' ;
https://techdocs.broadcom.com/us/en/ca-mainframe-software/automation/ca-workload-automation-ca-7-edition/12-1/search.html?q=sql&page=1