Schedules can be used to automatically run a Workflow, or several Workflows in a specific order, at regular intervals.
To create a Schedule:
The Schedule will appear in the Schedules list where you can see when the Next run will occur, or "Not Enabled" if the Schedule has not yet been activated.
To stop an active Schedule, click Options > Disable.
A CRON expression is a string of either 6 or 7 fields, separated by white space, that can be used as a shorthand way of defining a recurring schedule.
To create a CRON expression use the following fields:
Field | Required? | Allowed Values | Allowed Special Characters |
---|---|---|---|
Seconds | Required | 0-59 | *-/, |
Minutes | Required | 0-59 | *-/, |
Hours | Required | 0-23 | *-/, |
Day of month | Required | 1-31 | ?*-/,LW |
Month | Required | 1-12 or JAN-DEC | *-/, |
Day of week | Required | 1-7 or SUN-SAT | ?*-/,L# |
Year | Optional | 1970-2099 | *-/, |
Some example CRON expressions:
0 0 0 1W * ? 2020
will run the schedule at midnight on the first weekday of each month in 20200 15 0 1/2 * ?
will run the schedule at quarter past midnight every other day (for the current year)0 0 9-17 ? * MON-FRI 2020-2022
will run the schedule every hour between 9AM and 5PM Monday to Friday, between 2020 and 2022 As well as running at the defined interval, a Schedule can be run as a one-off event for immediate execution in two ways:
When you click on the Run now, a Run Schedule dialog will appear, and you can specify the execution details for each Workflow in the Schedule such as version, sources and parameters.
The Version to run setting decides whether to use Draft or Published version of the Workflows to execute.
You can also select Prefer drafts or Only use published dependencies to run. This setting decides whether to execute the Workflows using unpublished dependencies, such as Views and Functions.
By ticking Refresh sources, the source that allows auto-refresh will be refreshed from their external source prior to execution.
You may need to configure the replaceable sources for each Workflow in the Schedule (if available).
The source replacements that you have defined in the schedule will be populated here, but you can still replace it with an uploaded dataset from the dataset list and perform column mapping if the selected source have different/ missing columns.
Optional sources will use the configured source for execution, otherwise the default source will be used.
You may need to configure the re-configurable Workflow parameters for each Workflow in the Schedule (if available).
The parameters' value that you have defined in the schedule will be populated here, but you can still replace it with other value.
Optional Workflow parameters will use the configured value for execution, otherwise the default value will be used.
Go to Jobs to review the status of running and completed job. For Workflow executions triggered by a Schedule, the Initiated by column will indicate which Schedule initiated the job. Click Options on the job to see more information such as the status and duration.