Using pg_cron

Use pg_cron to schedule various database maintenance and management tasks.

Viewing the job status

select * from cron.job_run_details order by start_time desc limit 10;

Purging the cron.job_run_details table

SELECT cron.schedule('0 0 * * *', $$DELETE 
    FROM cron.job_run_details 
    WHERE end_time < now() - interval '14 days'$$);

For more information on using pg_cron, see the pg_cron documentation.

• On this page
• Viewing the job status
• Purging the cron.job_run_details table