How to determine how many total jobs are in CA7 r12
Article ID: 132618
Updated On:
Products
CA 7 Workload Automation
Issue/Introduction
How do you determine how many jobs are currently in CA7 R12
Environment
Release: SEVDT.99000-12.0-Workload Automation-CA 7 Edition
Component:
Component:
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 = 'CA7R120' ;
The output will look like this:
INPUT STATEMENT:
SELECT COUNT(*) FROM CA7_JOB
WHERE DB = 'CA7R120' ;
COUNT(*)
___________
61231
___ 1 row returned ___
//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 = 'CA7R120' ;
The output will look like this:
INPUT STATEMENT:
SELECT COUNT(*) FROM CA7_JOB
WHERE DB = 'CA7R120' ;
COUNT(*)
___________
61231
___ 1 row returned ___
Feedback
Yes
No
Powered by
