CREATE OR REPLACE SNAPSHOT

6.0-SNAPSHOT 5.5 5.4 5.3 5.2 5.1 5.0

The CREATE OR REPLACE SNAPSHOT statement creates a named snapshot that you can use to start other jobs or keep as a backup.

After you create a snapshot, the job will continue running. If you want to cancel the job after creating a snapshot, use the DROP JOB WITH SNAPSHOT statement.

Syntax Summary

This code block is a quick reference with all the parameters that you can use with the CREATE OR REPLACE SNAPSHOT statement.

See some practical examples.

CREATE OR REPLACE SNAPSHOT snapshot_name FOR JOB job_name

Parameters

The CREATE OR REPLACE SNAPSHOT statement accepts the following parameters.

All of these parameters are required.

Parameter Description Example

snapshot_name

Name the snapshot. If the snapshot already exists, it is overwritten.

Create a Snapshot

job_name

Define the job for which to create the snapshot.

Create a Snapshot

Examples

This section lists some example SQL queries that show you how to use the CREATE OR REPLACE SNAPSHOT statement.

Create a Snapshot

CREATE OR REPLACE SNAPSHOT track_trades_snapshot FOR JOB track_trades;
lifebuoy

Help and support