Scheduled Query
A database query configured to run automatically at specified times or intervals.
In Depth
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.
How AI for Database Helps
AI for Database lets you schedule any query to run on a cadence and delivers results via email, Slack, or dashboard updates.
Related Terms
Database Automation
The use of software to perform recurring database tasks—backups, monitoring, alerts, and report generation—without manual intervention.
Workflow
A sequence of automated steps triggered by an event or schedule that processes data and takes actions.
Cron
A time-based job scheduling system that runs commands or scripts at specified times and intervals.
Ready to try AI for Database?
Query your database in plain English. No SQL required. Start free today.