How to create scheduled jobs in PostgreSQL?


PostgreSQL doesn't have the concept of scheduled jobs.

You can use

With these, just use psql to connect the db and feed it a sql file.

psql -d myDb -f "mySQL.sql"

If you want an EXTENSION that does some of this, you can check out pg_cron.


You can configure your recurring tasks by creating database jobs in PostgreSQL. PostgreSQL provides one external tool to configure PostgreSQL jobs, its name is PGAgent.

PGAgent (a part of pgAdminIII) is an external tool by the Postgres community which is used to create and manage database jobs.

For your further reference: How to create job in PostgreSQL


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.