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');