ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to determine how many total jobs are in CA7 r12

book

Article ID: 132618

calendar_today

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:

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 ___