What tables contain history and are affected by DB_maint?

Products

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

Issue/Introduction

Introduction: 

What tables contain history and are affected by DB_maint?

 

Question: 

What tables contain history and are affected by DB_maint script?

 

 

Environment:  

11.3.X Autosys and above

 

Answer: 

The following tables are:

(Create aedbadmin)

 

ujo_proc_event 

ujo_alarm 

ujo_job_runs 

ujo_audit_info 

ujo_audit_msg 

ujo_extended_jobrun_info 

ujo_job_status 

ujo_job_tree 

ujo_job_resource_dep 

ujo_job_cond 

Environment

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