Automatic Job Aging Job

Overview

The Automatic Job Aging System is a critical system component that manages the automated purging of completed jobs based on configurable retention policies. This system optimizes database performance and storage utilization by systematically removing obsolete job records according to predefined criteria. The system operates through three primary configuration parameters that control retention duration, execution frequency, and scheduling.

Configuration Properties

maxjobage

• Description: Specifies the maximum retention period (in minutes) for completed jobs before they become eligible for purging
• Data Type: Integer
• Default Value: 0 (disables automatic purging)
• Examples:
  • maxjobage = 1440 (purge jobs older than 1 day)
  • maxjobage = 43200 (purge jobs older than 30 days)

maxjobagefrequencyindays

• Description: Defines the execution interval (in days) for the purging process
• Data Type: Integer
• Default Value: 1 (daily execution)
• Example: maxjobagefrequencyindays = 7 (executes weekly)

ebp.maxjobagestarttime

• Description: Specifies the hour of day (24-hour format) when the purging process initiates
• Data Type: Integer (0-23)
• Default Value: 2 (2:00 AM)
• Example: ebp.maxjobagestarttime = 2 (process begins at 2:00 AM)

Execution Workflow

The Automatic Job Aging System follows a systematic execution process:

1. Scheduled Activation: The system initiates at the specified start time according to the configured frequency interval
2. Database Query: Executes a query to identify completed jobs that exceed the defined retention period
3. Data Purging: Removes qualifying job records from the database to maintain optimal system performance
4. Process Completion: Logs execution results and prepares for the next scheduled cycle

Configuration Examples

Daily Purging (1 Day Retention)

maxjobage = 1440
maxjobagefrequencyindays = 1
ebp.maxjobagestarttime = 2

Purges jobs older than 24 hours, runs daily at 2:00 AM

Monthly Purging (30 Day Retention)

maxjobage = 43200
maxjobagefrequencyindays = 7
ebp.maxjobagestarttime = 3

Purges jobs older than 30 days, runs weekly at 3:00 AM