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.

sql

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.	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 EditionThis feature requires Hazelcast Enterprise, a licensed edition of the Hazelcast Platform.	Delete a Job

Examples

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

Delete a Job

sql

DROP JOB IF EXISTS track_trades WITH SNAPSHOT track_trades_snapshot;