Antananarivo, Madagascar - April 19, 2026 ## PostgreSQL DBMS_JOB compatibility extension
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. - 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](https://github.com/HexaCluster/pg_dbms_job/blob/v2.0/ChangeLog) ## Links & Credits pg_dbms_job is an open project under the PostgreSQL license created by Gilles Darold at [Hexacluster Corp.](https://hexacluster.ai/) 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/](https://github.com/HexaCluster/pg_dbms_job/releases/) * Support: use GitHub report tool at [https://github.com/HexaCluster/pg_dbms_job/issues](https://github.com/HexaCluster/pg_dbms_job/issues) ## About pg_dbms_job The pg_dbms_job extension is an original work of [Hexacluster Corp.](https://hexacluster.ai/), a canadian company specialized in migration to PostgreSQL and PostgreSQL support. If you need more information please [contact us](https://hexacluster.ai/contact-us/) Documentation at [https://github.com/HexaCluster/pg_dbms_job#readme](https://github.com/HexaCluster/pg_dbms_job#readme)
