SYSCS_UTIL.SYSCS_CANCEL_DAILY_BACKUP

The SYSCS_UTIL.SYSCS_CANCEL_DAILY_BACKUP system procedure cancels a scheduled backup job.

Once you cancel a daily backup, it will no longer be scheduled to run.

Syntax

SYSCS_UTIL.SYSCS_CANCEL_DAILY_BACKUP( BIGINT jobId );

jobId

BIGINT value that specifies which scheduled backup job you want to cancel.

To find the jobId you want to cancel, see the Backing Up and Restoring topic.

Results

This procedure does not return a result.

Execute Privileges

If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this function by default. The database owner can grant access to other users.

Example

If necessary, you can first query the SYSBACKUPJOBS system table to find the jobId of the job you want to cancel.

And then cancel that job; for example:

splice> SELECT * FROM SYS.SYSBACKUPJOBS;
JOB_ID      |FILESYSTEM                               |TYPE          |HOUR_OF_DAY|BEGIN_TIMESTAMP
-------------------------------------------------------------------------------------------------
41069       |/~/Documents/splicemachine/dbBackups/    |full          |18         |09:41:05.455

1 row selected

splice> CALL SYSCS_UTIL.SYSCS_CANCEL_DAILY_BACKUP(41069);
Statement executed.

See Also