pg_cron

Run periodic jobs in PostgreSQL

brewmacoslinux

Try with needOr install directly

About

Run periodic jobs in PostgreSQL

pg_cron

Schedule a job to vacuum a table every day at 3 AM$ SELECT cron.schedule('vacuum-my-table', '0 3 * * *', 'VACUUM my_table');

Schedule a job to run every 10 minutes$ SELECT cron.schedule('frequent-job', '*/10 * * * *', 'SELECT my_function();');

List all scheduled cron jobs$ SELECT * FROM cron.job;