autorep - Autosys job run data not accesible

Products

• Autosys Workload Automation
• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

Autosys job run data not accessible post the Autosys scheduler server reboot activity done on 17th . The run data for any job is not accessible before 17th July.

 

Environment

Release : 11.3.6

Component : CA WORKLOAD AUTOMATION ADVANCED INTEGRATION FOR HADOOP

Resolution

The issue was not with the server reboot that was just a coincidence. The root cause of the issue was that the DBMaint script in $AUTOSYS/bin was modified from keeping  7 days data (default) to keep just 2 days.

The DBMaint script in $AUTOSYS/bin was modified as below

# Archive the Events
archive_events -A -n 2 -b 50000  >> $outfile 2>&1
ecode=`expr $? + $ecode`

# Archive the job_runs
archive_events -A -j 2  -b 50000 >> $outfile 2>&1
ecode=`expr $? + $ecode`

# Archive the autotrack log
archive_events -A -l 2  -b 50000 >> $outfile 2>&1
ecode=`expr $? + $ecode`

# Archive the jobs
archive_jobs -j 2 >> $outfile 2>&1
ecode=`expr $? + $ecode`

For more details refer to the product documentation

archive_events Command -- Archive Data

The DBMaint is configured to run in the config file with the parameters DBMaintTime and DBMaintCmd. For more information refer to the link below.

DBMaintTime and DBMaintCmd