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.
WAAE 11.3.6 SP4 on Linux + Oracle
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 ;