pgsql-announce
❮
pg_dbms_job v2.0 released
- Jump to comment-1HexaCluster via PostgreSQL Announce<announce-noreply@postgresql.org>Apr 20, 2026, 1:20 AM UTCAntananarivo, Madagascar - April 19, 2026
## PostgreSQL DBMS_JOB compatibility extension
pgdbmsjob is a new PostgreSQL extension to create, manage and use Oracle-style DBMSJOB scheduled job. The use and behavior is just like with the DBMSJOB 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.
Complete list of changes is available here- 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.
## Links & Credits
pgdbmsjob 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 :
* Download: https://github.com/HexaCluster/pg_dbms_job/releases/
* Support: use GitHub report tool at https://github.com/HexaCluster/pg_dbms_job/issues
## About pgdbmsjob
The pgdbmsjob 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