pg_dbms_job v2.0 releasedAntananarivo, Madagascar - April 19, 2026 PostgreSQL DBMS_JOB compatibility extensionpg_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. - Rewrite scheduler Perl external daemon into a background worker in C.
- Add
pg_dbms_job.naptime configuration parameter to change default value of 100 ms. - Ability to set decimal value for GUC
pg_dbms_job.job_queue_interval. - Use interval unit for run_duration column intead of integer for more precise value.
- Set
$pg_dbms_job$ as a block for job execution to avoid conflict with the code executed.
Complete list of changes is available here Links & Creditspg_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 : About pg_dbms_jobThe 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 |