Schedules and alerts
A schedule runs one saved query on a cadence and emails the members you choose when the result meets a condition you set. It runs as the query's owner, so you can only schedule a query you are able to run.
When to use
Unattended monitoring and reporting. Email me when a query returns rows, returns nothing, errors, crosses a row count, or a value in the first row crosses a threshold.
Create a schedule
- Go to Schedules and choose New schedule.
- Set the Name and pick the Query. The list shows only queries you can run, and you cannot change the query after you create the schedule.
- If the query has variables, supply their values.
- Set the Cadence, either:
- Interval, set with Every (minutes), or
- Cron, a five-field expression (for example
*/15 * * * *) plus a Timezone.
- Set the Alert when condition:
- Any rows returned / No rows returned
- Row count comparison (
>,<,=a number) - Query errored
- Column threshold (compare a column in the first row against a number or text value).
- Choose Recipients, the organization members to email when the alert triggers.
- Create the schedule. It starts enabled.
On the list, each row has a switch to enable/disable it, plus History, Edit, and Delete. History shows each run, whether it triggered the alert, and when an email went out.
Cadence limits and gating
Your plan sets a minimum interval (a schedule may not fire more often than that), and scheduling is a paid feature gated on the Scheduling entitlement. Without it the page shows an upgrade prompt (Scheduled queries are a paid feature) with a View plans button to Admin → Billing.