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 |