search cancel

What tables contain history and are affected by DB_maint?

book

Article ID: 42483

calendar_today

Updated On:

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: