Skip To Content

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 typeJob statusClean 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