CREATE OR REPLACE SNAPSHOT (Enterprise only)
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