How to verify the number of jobs in WAAE AutoSys instance ?

Document ID : KB000045743
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

 

 
We have thousands of jobs created in our AutoSys instance.
We need to know how to verify the exact number of jobs in an AutoSys instance.
 

Environment: 

 
WAAE 11.3.6 SP4 on Linux + Oracle
 
 

 

Answer: 

 
There are several possible solutions which will allow to verify the exact number of jobs in an AutoSys instance.
 
You can either use the "autorep -J ALL" command as in the following example :
 
autorep -J ALL | wc -l
 
 
Or run the following database query to get the result faster when there is a very large number of jobs created :
 
select count(*) from aedbadmin.ujo_job
where IS_ACTIVE = 1
and IS_CURRVER = 1 ;