Icon RESET JOB

Resets an existing job.

Syntax
RESET JOB <Name>

Usage
Use this statement to reset a job. When a job is reset, the last run timestamp for the job is cleared. Subsequently, ElevateDB treats the job as never having been executed for scheduling purposes.

Information This is a persistent change that is saved in the current ElevateDB Server configuration file.

Examples
-- The following statement resets the Backup job

RESET JOB "Backup"

Required Privileges
The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
ExtensionThis SQL statement is an ElevateDB extension.
Image