CREATE MAINTENANCE POLICY¶

Syntax¶

CREATE [ OR REPLACE ] MAINTENANCE POLICY [ IF NOT EXISTS ] <name>
  SCHEDULE = 'USING CRON <cron_spec> <timezone>'
  [ COMMENT = '<comment>' ]

Required parameters¶

name

Specifies the identifier of the maintenance policy. The identifier must be unique within the schema.

SCHEDULE = 'USING CRON cron_spec timezone

Specifies the schedule for the maintenance policy. This parameter uses the same syntax as the SCHEDULE parameter of the CREATE TASK command.

Optional parameters¶

COMMENT = 'comment'

Specifies an optional comment for the maintenance policy.

Usage notes¶

• Each app or account can have only one maintenance policy.

Access control requirements¶

A role used to execute this SQL command must have at least one of the following privileges at a minimum:

Examples¶

The following example creates a maintenance policy that schedules upgrades for Saturdays at 2 AM UTC:

CREATE MAINTENANCE POLICY my_maintenance_policy
  SCHEDULE = 'USING CRON 0 2 * * SAT UTC'
  COMMENT = 'Weekly Saturday maintenance window';