Glossary · Automation

Scheduled Query

A database query configured to run automatically at specified times or intervals.

A scheduled query is a SQL query that executes automatically at predefined intervals (hourly, daily, weekly) or at specific times. Scheduled queries are used for recurring reports, data aggregation, materialized view refreshes, data quality checks, and metric calculations. The scheduling system handles execution timing, retry logic on failures, result storage or distribution, and notification of completion or errors. Modern database platforms and BI tools include built-in query scheduling, while general-purpose schedulers like cron, Apache Airflow, and cloud scheduler services can also trigger database queries.

Fig — every answer ships with the tables, rows and SQL behind it.