public inbox for pgsql-announce@postgresql.org  

help / color / mirror / Atom feed

From: HexaCluster via PostgreSQL Announce <announce-noreply@postgresql.org>
To: PostgreSQL Announce <pgsql-announce@lists.postgresql.org>
Subject: pg_dbms_job v2.0 released
Date: Mon, 20 Apr 2026 01:15:51 +0000
Message-ID: <177664775155.403057.16279056068265365547@wrigleys.postgresql.org> (raw)

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)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-announce@postgresql.org
  Cc: announce-noreply@postgresql.org, pgsql-announce@lists.postgresql.org
  Subject: Re: pg_dbms_job v2.0 released
  In-Reply-To: <177664775155.403057.16279056068265365547@wrigleys.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox