Antananarivo, Madagascar - April 19, 2026
pg_dbms_job is a new PostgreSQL extension to create, manage and use Oracle-style DBMS_JOB scheduled job. The use and behavior is just like with the DBMS_JOB Oracle package.
This PostgreSQL extension allows to manage scheduled jobs from a job queue or to execute immediately jobs asynchronously. A job definition consist on a code to execute, the next date of execution and how often the job is to be run. A job runs a SQL command, plpgsql code or an existing stored procedure.
This major release is a rewrite of the Perl scheduler into a PostgreSQL background worker written in C with some other improvements.
pg_dbms_job.naptime configuration parameter to change default value of 100 ms.pg_dbms_job.job_queue_interval.$pg_dbms_job$ as a block for job execution to avoid conflict with the code executed.Complete list of changes is available here
pg_dbms_job is an open project under the PostgreSQL license created by Gilles Darold at Hexacluster Corp. as part of the improvement of Ora2Pg. Any contribution to build a better tool is welcome. You can send your ideas, features requests or patches using the GitHub tools.
Links :
The pg_dbms_job extension is an original work of Hexacluster Corp., a canadian company specialized in migration to PostgreSQL and PostgreSQL support. If you need more information please contact us
Documentation at https://github.com/HexaCluster/pg_dbms_job#readme