Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wEdIt-004EHV-30 for pgsql-announce@arkaria.postgresql.org; Mon, 20 Apr 2026 01:20:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wEdIs-000215-2h for pgsql-announce@arkaria.postgresql.org; Mon, 20 Apr 2026 01:19:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wEdFD-00HHbY-1m for pgsql-announce@lists.postgresql.org; Mon, 20 Apr 2026 01:16:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wEdF8-00000001qbh-1gwy for pgsql-announce@lists.postgresql.org; Mon, 20 Apr 2026 01:16:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=1eMWn1dgPpK2xAAQIEwUbkHwWJLsBiki4v+If77E9so=; b=sal3wpZO2nejwknLzpsj4GLaCG 4P9cNGpF/GYxGWaRyDWzZ7JdQTrgTRU93h3ThmFSs4NctMzoNrAdQhVRxSKEXB+nXZQKSOJQ4GWdz o4+kxvAq+KonNmaXhqCXx0HPi2bhWwZeq/6L/QvZmRfnK1hlGJtegQo2IpX/7v8Nrfk9vvUEEsHSr O9IImu2M28Km64HgGC1KrJxtLJPln+ogMy56o7GBZXXYjYfoyCDW3U/WT+zWY4DOj5T2tJ8VBAoQC 96MQ8o43rDN0AUk3NjRxnBz4ZwATDXvYbNn2p4Tk7IELVgQXxtisPrDa+rLFByKB7hCUxZty/5bPA WEYdwPuw==; Received: from wrigleys.postgresql.org ([217.196.149.60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wEdF7-005UpJ-0t for pgsql-announce@lists.postgresql.org; Mon, 20 Apr 2026 01:16:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wEdF5-00CF0i-0v for pgsql-announce@lists.postgresql.org; Mon, 20 Apr 2026 01:16:03 +0000 Content-Type: multipart/alternative; boundary="===============1520736448499799321==" MIME-Version: 1.0 Subject: pg_dbms_job v2.0 released To: PostgreSQL Announce From: HexaCluster via PostgreSQL Announce Reply-To: gilles@hexacluster.ai Date: Mon, 20 Apr 2026 01:15:51 +0000 Message-ID: <177664775155.403057.16279056068265365547@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: a8de3efdf4102db54fb8f3cd099db0888345d84111a0b5d6b31b101b0e0bc7c7 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1520736448499799321== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable 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 DB= MS_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 b= e run. A job runs a SQL command, plpgsql code or an existing stored procedu= re. This major release is a rewrite of the Perl scheduler into a PostgreSQL bac= kground 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 val= ue 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 pr= ecise 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 Gill= es Darold at [Hexacluster Corp.](https://hexacluster.ai/) as part of the improvement of Ora2Pg. Any contribution to build a better t= ool 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_dbm= s_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 PostgreS= QL 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) --===============1520736448499799321== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable pg_dbms_job v2.0 released
 

pg_dbms_job v2.0 released

Antananarivo, Madagascar - April 19, 2026

PostgreSQL DBMS_JOB compatibili= ty extension

pg_dbms_job is a new PostgreSQL extension t= o create, manage and use Oracle-style DBMS_JOB scheduled job. The use and b= ehavior 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 asynchronous= ly. A job definition consist on a code to execute, the next date of executi= on and how often the job is to be run. A job runs a SQL command, plpgsql co= de 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 schedul= er Perl external daemon into a background worker in C.
  • Add pg_db= ms_job.naptime configuration parameter to change default value of 10= 0 ms.
  • Ability to set = decimal value for GUC pg_dbms_job.job_queue_interval.
  • Use interval un= it for run_duration column intead of integer for more precise value.
  • Set $pg_d= bms_job$ as a block for job execution to avoid conflict with the cod= e executed.

Complete list of changes is available here

Links & Credits

pg_dbms_job is an open project under the Po= stgreSQL license created by Gilles Darold at Hexacluster Corp= . as part of the improvement of Ora2Pg. Any contribution to build a better t= ool is welcome. You can send your ideas, features requests or patches using the GitHub tools.

Links :

About pg_dbms_job

The pg_dbms_job extension is an original wo= rk of Hexacluster Corp., a canadian company specialized i= n migration to PostgreSQL and PostgreSQL support. If you need more informat= ion please contact us

Documentation at https://github.com/HexaCluster/pg_dbms_job#readme
This email was sent to you from HexaCluster. It was delivered on their beha= lf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to HexaCluster.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============1520736448499799321==--