Advanced Reporting

Scheduling SQL Jobs

Senior Data Analyst
April 3, 2026
5 min read

The Need

Every night at midnight, archive old orders and refresh materialized views.

Tools

  • **PostgreSQL**: `pg_cron` extension.
  • **SQL Server**: SQL Server Agent.
  • **External**: Cron jobs, Airflow, or dbt.

    • pg_cron Example

    SELECT cron.schedule('nightly-archive', '0 0 * * *', 'CALL archive_old_orders()');

    *Day 94: Data Governance and Security.*

    Ready to put your knowledge into practice?

    Join SQL Mastery and learn through interactive exercises.