A CRON expression specifies recurring task execution by minute, hour, day of month, month, and day of week. In Snowflake, provide a time zone to make the schedule unambiguous. section 2.5
Apply a CRON schedule operationally:
- Suspend the task before changing its schedule. section 2.5
- Set the schedule with the CRON expression and time zone. section 2.5
- Resume the task, then use TASK_HISTORY() to verify execution and the next scheduled time. section 2.5
Run every evening at 11 p.m.
The expression `0 23 * * * UTC` means minute 0, hour 23, every day of the month, every month, and every day of the week, using UTC. section 2.5
alter task PROCESS_ORDERS suspend; alter task PROCESS_ORDERS set schedule = 'USING CRON 0 23 * * * UTC'; alter task PROCESS_ORDERS resume;
Shows the complete suspend, alter, and resume sequence for applying a CRON schedule to a Snowflake task. section 2.5
