Cron Expression Syntax

Standard 5-field cron. Fields: minute (0-59), hour (0-23), day-of-month (1-31), month (1-12), day-of-week (0-7, 0 and 7 = Sunday).

Category: schedule-defaults

Syntax

minute hour day-of-month month day-of-week

Description

This reference topic explains the five-field cron expression format accepted by both the `SCHEDULE` clause on a `PIPELINE` declaration and the `CRON` clause on a standalone `SCHEDULE` command. Each expression consists of five space-separated fields in the order `minute hour day-of-month month day-of-week`, where valid ranges are 0-59, 0-23, 1-31, 1-12, and 0-7 respectively (both 0 and 7 represent Sunday in the day-of-week field). Supported operators include the wildcard `*` (match every value), step `*/N` (every N intervals, e.g., `*/15` in the minute field fires at 0, 15, 30, 45), range `N-M` (inclusive span, e.g., `9-17` for business hours), and list `N,M,O` (discrete values, e.g., `1,15` for the 1st and 15th of the month). For example, `SCHEDULE '30 6 * * 1-5'` triggers at 06:30 every weekday, and `SCHEDULE '0 */2 * * *'` triggers every two hours on the hour. The cron expression is always evaluated against the timezone specified by the `TIMEZONE` clause; when no timezone is provided, evaluation defaults to UTC.

Open in interactive docs →   DeltaForge home →