How to Schedule a Query
Last updated
Was this helpful?
Last updated
Was this helpful?
You can use scheduled query executions to keep your dashboards updated or to power routine Alerts. By default, your queries will not have a schedule. But this is easy to adjust. In the bottom left corner of the query editor you’ll see the schedule area.
Clicking Never will open a picker with allowed schedule intervals.
Your query will run automatically once a schedule is set.
When you schedule queries to run at a certain time-of-day, the application converts your selection to UTC using your computer’s local timezone. That means if you want a query to run at a certain time in UTC, you need to adjust the picker by your local offset.
For example, if you want a query to execute at 00:00 UTC each day but your current timezone is CDT (UTC-5), you should enter 19:00 into the scheduler. The UTC value is displayed to the right of your selection to help confirm your math.
The application has the ability to email query owners once per hour if one or more queries failed. These emails continue until there are no more failures. Failure report emails run on an independent process from the actual query schedules. It may take up to an hour after a failed query execution before the application sends the failure report.
You can toggle failure reports from your organizations settings. Under Feature Flags check Email query owners when scheduled queries fail.
