DROP JOB
The DROP JOB
statement cancels a job and gives you the option to create a named snapshot from its state.
Syntax Summary
This code block is a quick reference with all the parameters that you can use with the DROP JOB
statement.
See some practical examples.
DROP JOB [IF EXISTS] job_name [WITH SNAPSHOT snapshot_name]
Parameters
The DROP JOB
statement accepts the following parameters.
The job_name
parameter is required.
Parameter | Description | Example |
---|---|---|
IF EXISTS |
Do nothing if the job either does not exist or is no longer running. |
|
job_name |
The name of the job to delete. |
|
WITH SNAPSHOT |
Create a named snapshot of the job before canceling it. Enterprise |