From: | MigOps via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
---|---|
To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
Subject: | pg_dbms_job v1.5.0 released |
Date: | 2022-10-02 16:50:19 |
Message-ID: | 166472941958.662.2706300812023074847@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
October 2, 2022
## PostgreSQL DBMS_JOB compatibility extension
pg_dbms_job is a 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.
It 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.
pg_dbms_job v1.5.0 has been released, this is a maintenance release to fix
a major issue reported by users since the past two months.
* Fix get_scheduled_jobs() to avoid executing already running jobs if it
takes longer to complete than the frequency at which it is programmed.
Complete list of changes and acknowledgement is available [here](https://github.com/MigOpsRepos/pg_dbms_job/blob/main/ChangeLog)
## Links & Credits
pg_dbms_job is an open project under the PostgreSQL license created by Gilles Darold at [MigOps Inc](https://migops.com/)
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/MigOpsRepos/pg_dbms_job/releases/](https://github.com/MigOpsRepos/pg_dbms_job/releases/)
* Support: use GitHub report tool at [https://github.com/MigOpsRepos/pg_dbms_job/issues](https://github.com/MigOpsRepos/pg_dbms_job/issues)
## About pg_dbms_job
The pg_dbms_job extension is an original work of [MigOps Inc](https://migops.com/), MigOPs is specialized in migration to PostgreSQL and PostgreSQL support. If you need more information please [contact us](https://www.migops.com/contact-us/)
Documentation at [https://github.com/MigOpsRepos/pg_dbms_job#readme](https://github.com/MigOpsRepos/pg_dbms_job#readme)
From | Date | Subject | |
---|---|---|---|
Next Message | IVM Development Group via PostgreSQL Announce | 2022-10-03 07:51:47 | pg_ivm 1.3 released |
Previous Message | 토토 사이트 | 2022-09-29 13:06:47 | PostgreSQL 15 RC 1 Released! |