This is a prerelease version.

View latest

DROP JOB

The DROP JOB statement cancels a job and gives you the option to create a named snapshot from it.

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

Fail silently 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 only).

Examples

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

Delete a Job

DROP JOB IF EXISTS track_trades WITH SNAPSHOT track_trades_snapshot;