Question:
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?
Answer:
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:
Example:
$ 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.