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

book

Article ID: 36985

calendar_today

Updated On:

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: