Is there a delete all option for autoaggr?

Document ID : KB000010969
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Is there a delete all option for the autoaggr command?

Environment:
Product: Workload Automation AE 11.x Platform: Windows, UNIX, Linux Database: Oracle, Sybase, MS SQL
Answer:

The command "autoaggr" has a -r flag, which deletes the current aggregated data and reaggregates.

The database tables:

  UJO_REP_DAILY 
  UJO_REP_HOURLY    
  UJO_REP_MONTHLY    
  UJO_REP_WEEKLY 

Will be truncated and then repopulated with the data that autoaggr can read based on what is currently in the AutoSys MDB. 
The autoaggr reads from other AutoSys tables like ujo_alarm, ujo_proc_event, ujo_job_runs.