Removing validation jobs from the scheduler database

There are two types of automated validation jobs, on demand and scheduled.

On demand jobs are also known as adhoc jobs. The server executes an on demand job immediately and one time only. If validation completes successfully, the job's status is set to Completed. A job with a status of Completed will not execute again.

Scheduled jobs execute repeatedly according to a schedule until the job's maxNumberOfExecutions property exceeded. Once this condition is true, the job's status is set to Completed. The job will not execute again.

Removing jobs from the scheduler database

Scheduled and adhoc batch validation jobs are periodically removed from the scheduler database. Removal is automatic and controlled by the Data Reviewer Server extension. The extension checks the database once per 60 minutes for jobs to remove.

The following table details when each type of job is removed from the scheduler database.

Validation type	Job status	Clean up interval
On demand (adhoc)	Completed	24 hours after validation finish time
On demand (adhoc)	Executing	24 hours after validation creation time if job execution does not successfully start
Scheduled	Completed	24 hours after maxNumberOfExecutions is exceeded