Database cleanup for CA Scheduler Job Management r11.0.

Products

• Datacom
• DATACOM - AD
• Scheduler Job Management

Issue/Introduction

How to delete obsolete audit, mailbox, and history records from your CA Scheduler JM database.

 

Environment

Release: 11.0
Component: CA Scheduler Job Management

Resolution

Solution:

There are three types of records that can be deleted from your CA Scheduler JM database: audit trail, mailbox information and job history records.

CA Scheduler JM installation step 34, Define/Update Cleanup Job (named CHCLEAN by default) defines a cleanup job to issue these commands to run every day. These commands are:

 

 	DELETE AUDIT KEEP=n 	 	DELETE MAILBOX KEEP=n      	DELETE HISTORY LIST=YES|NO 

 

The AUDIT, MAILBOX and HISTORY records stay in your database until you tell CA Scheduler JM to delete them.

For AUDIT and MAILBOX, the "KEEP=" value on both commands is the number of days worth of data to keep. You might want to keep only 3 days worth of data, or you might want to keep 7 days of audit trail and 14 days of mailbox. You control how long your data is kept. If your site requires to retain a longer period of time for audit purposes, you can run a CAJUTIL0 job to issue the REPORT AUDIT and REPORT MAILBOX commands and route the output to a dataset before deleting them from the database.

The DELETE HISTORY will delete history records which meets the requirement for deletion that are set by the HISTRET and HISTNUM values in the CA Scheduler JM Initialization Options. HISTRET is the minimum number of history retention days. HISTNUM is the number of history occurrences to be kept. Both HISTRET and HISTNUM values must be met before the record can be deleted. Also, note that these options can also be overridden at the schedule or job level.

The "LIST=" value determines whether the list of each occurrence of each job and schedule found in the history database should be displayed, along with the disposition of each occurrence (that is, whether it is deleted or retained).

Every copy of CA Scheduler JM needs to have a cleanup job run on a regular basis to delete old audit trail, mailbox data or history records. If your site runs both production and development copies of CA Scheduler JM, then you need both production and development cleanup jobs.

Deleting obsolete audit trail, mailbox data and history records keeps your database nice and tidy and prevents it from growing over time.