Integration
pg_cron
is a PostgreSQL extension providing cron-like functionality.
Check it's enabled
select *
from pg_ extension
where extname = 'pg_cron';
List scheduled events
select *
from cron.job;
Schedule an event
select cron.schedule('0 * * * *', $$
delete
from events
where created_at < now() - interval '1 month'
$$, 'delete_old_events');
Remove events
select cron.unschedule('delete_old_events');