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

  1. Go to Schedules and choose New schedule.
  2. 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.
  3. If the query has variables, supply their values.
  4. Set the Cadence, either:
    • Interval, set with Every (minutes), or
    • Cron, a five-field expression (for example */15 * * * *) plus a Timezone.
  5. 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).
  6. Choose Recipients, the organization members to email when the alert triggers.
  7. 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.