How do I schedule a query and get an alert?

Run a saved query on a repeating schedule and get an email when the result meets a condition you set. Scheduling is available on paid plans.

1. In the left rail, open Schedules.
2. Click New schedule.
3. Enter a Name and pick the Query to run. Only queries you can run are listed.
4. If the query has variables, fill in the values to use on each run.
5. Set the Cadence:
   • Choose Interval and set Every (minutes), or
   • Choose Cron and enter a 5-field expression such as */15 * * * *.
   • Pick a Timezone.
6. Under Alert when, choose what triggers an email: Any rows returned, No rows returned, Row count comparison, Query errored, or Column threshold. Fill in the number or column the condition needs.
7. Add one or more Recipients. Each recipient must be a member, and each one runs the query under their own access.
8. Click Create.

Squeezle now runs the query on your cadence and emails the recipients whenever the alert condition is met.

For cadence limits and how alerts run, see the Schedules and alerts guide.