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.

DROP JOB [IF EXISTS] job_name [WITH SNAPSHOT snapshot_name]

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.	Delete a Job
job_name	The name of the job to delete.	Delete a Job
WITH SNAPSHOT	Create a named snapshot of the job before canceling it. Enterprise Edition	Delete a Job

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 Edition

This section lists some example SQL queries that show you how to use the DROP JOB statement.

DROP JOB IF EXISTS track_trades WITH SNAPSHOT track_trades_snapshot;