How to determine how many total jobs are in CA7 r12

Products

• CA 7 Workload Automation

Issue/Introduction

How do you determine how many jobs are currently in CA7 R12?

Environment

WA CA 7 Edition

Release: r12.0 and above

Resolution

The following SQL job will query the CA7 R12.0 database and display the total number of jobs within CA7

//STEP1 EXEC PGM=DBSQLPR 
//STEPLIB DD DISP=SHR,DSN=CUSLIB 
//                DD DISP=SHR,DSN=CAAXLOAD 
//SYSPRINT DD SYSOUT=* 
//STDOUT DD SYSOUT=* 
//OPTIONS DD * 
PRTWIDTH=255 
INPUTWIDTH=70 
ROWLIMIT=5000 
AUTHID=MFWA 
NOTYPE 
//SYSIN DD * 
SELECT COUNT(*) FROM CA7_JOB 
WHERE DB = 'yourlogicaldbname' ; 



The output will look like this:

INPUT STATEMENT: 
SELECT COUNT(*) FROM CA7_JOB 
WHERE DB = 'yourlogicaldbname' ; 

COUNT(*) 
___________ 
61231 
___ 1 row returned ___