citusdata/pg_cron

This is stars and forks stats for /citusdata/pg_cron repository. As of 04 May, 2024 this repository has 2227 stars and 164 forks.

What is pg_cron? pg_cron is a simple cron-based job scheduler for PostgreSQL (10 or higher) that runs inside the database as an extension. It uses the same syntax as regular cron, but it allows you to schedule PostgreSQL commands directly from the database. You can also use '[1-59] seconds' to schedule a job based on an interval. pg_cron also allows you using '$' to indicate last day of the month. -- Delete old data on Saturday at 3:30am (GMT) SELECT cron.schedule('30 3 * * 6', $$DELETE FROM events...