search cancel

How to get the count of the AE jobs that were updated during a period of time.


Article ID: 36985


Updated On:


CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent



How can I get the number of AE jobs that were updated for a specific time period. For example, is there a way to count the number of jobs that were updated in December for instance?



If autotrack is enabled the ujo_audit* tables will contain information on job definition changes.

To confirm if autotrack is enabled run: autotack -l

It must be set to 1 or 2.


Next convert the date range you are looking for into AutoSys internal time using the time0 command: 



$ time0 -T 12/01/2015 

CAUAJM_I_50099 Autotime(internal): 1448949600 

$ time0 -T 01/01/2016 

CAUAJM_I_50099 Autotime(internal): 1451628000 


Then use the following sql if you want to get the count of update_job: commands were made during December, 2015. 

select count(*) from ujo_audit_info where type='J' and audit_info_num in (select distinct(audit_info_num) from ujo_audit_msg where is_edit='Y') and Time >= 1448949600 and time < 1451628000;


NOTE: By default autotrack data is only kept for 7 days.  After that it is archived to text files in the directory $AUTOUSER/archive

You can adjust the retention rate if desired, see archive_events and DBMaint for more details.


Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option