CA Workload Control Center QuickView job run history returns: "Does not have a run N times back".

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

Symptom:

When searching for a job run history in CA Workload Control Center, this message is returned:

"Does not have a run <N> times back".

 

Environment:

CA Workload Automation AE 11.0 SP5, 11.3.x on all supported platforms.

 

Cause:

By default, CA WA AE (Autosys) stores job run statistics for the last 7 days in the database. The DB Maintenance routine archives data older than 7 days.

 

Workaround:

The following configuration changes can be made to change the number of days for which the run statistics are saved.

Edit the $AUTOSYS/bin/DBMaint script and change the value for the archive_events commands to a value less than the default value of 7 as per the following settings:

-n num_of_days
Indicates that records older than the num_of_days should be deleted from the event table. The num_of_days value indicates the number of days of information that should be left in the database. If a row in the table is as old or older than this value, it will be deleted.

-j num_of_days
Indicates that the information older than the num_of_days should be deleted from the job_runs table. The num_of_days value indicates the number of days of information that should be left in the database. If a row in the table is as old or older than this value, it will be deleted.

-l num_of_days
Indicates that the autotrack information older than the num_of_days should be deleted from the audit_info and audit_msg tables. The num_of_days value indicates the number of days of information that should be left in the database. If a row in the table is as old or older than this value, it will be deleted.

 

Additional Information:

(UNIX) Modify the DBMaint Script

(Windows) Modify the DBMaint.bat File

CA Workload Automation AE & Workload Control Center - Reference Guide - archive_events