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

Article Id: 36985

Status: Published

Updated On: 14-02-2018 07:36

Legacy Id: TEC1185178

Products:

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

Issue/Introduction:

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.

Environment:

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