pg_cron schedules SQL jobs inside the database using cron syntax. Use it to refresh materialized views, clean up expired data, or run nightly aggregations. Manage jobs with cron.schedule() and monitor them easily.
Scheduling Jobs with pg_cron
CREATE EXTENSION pg_cron;
-- Run at midnight daily
SELECT cron.schedule(
'nightly-cleanup',
'0 0 * * *',
$$DELETE FROM logs WHERE created < NOW() - INTERVAL '30 days'$$
);
-- List jobs
SELECT * FROM cron.job;