search cancel

How to suppress autoaggr data for a time frame?


Article ID: 16752


Updated On:


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


Is there a way to purge autoaggr data based on a time range?


Autosys 11.3.6 on Linux but same question applies to all the other releases and platforms.


DBMaint is not designed to perform such operation. 

There is no utility to delete a selected range of records from these tables. 

You can delete ALL the aggregated job, alarm, and scheduler statistics in the following situations: 

- When you want the aggregation process to regenerate all statistics. 

- When you no longer want to store the aggregated statistics in the database. 

- When you delete aggregated statistics, the statistics in the ujo_rep_hourly, ujo_rep_daily, ujo_rep_weekly, and ujo_rep_monthly tables are deleted. 


Follow these steps: 

Open the UNIX operating system prompt or the Windows instance command prompt as follows: 

(UNIX) Run the shell that is sourced to use CA Workload Automation AE. 

The operating system command prompt appears. 

(Windows) Click Start, Programs, CA, Workload Automation AE, Command Prompt (instance_name). 

The instance command prompt appears. 

Enter the following command: 



These tables are not huge because:  

- ujo_rep_* tables should not have more than 8K 

- ujo_rep_daily table adds only 1 row per day. 

- ujo_dep_monthly adds only 1 row every month. 

- ujo_rep_weekly - adds one record every week. 

- ujo_rep_hourly - adds 1 record per hour.