Grenoble - April 11, 2022
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.
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.2.0 has been released, this is a maintenance release to fix issues reported by users since the past height months. It also adds some useful improvements.
Complete list of changes and acknowledgement is available here
pg_dbms_job is an open project under the PostgreSQL license created by Gilles Darold at MigOps Inc 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 :
The pg_dbms_job extension is an original work of MigOps Inc, MigOPs is specialized in migration to PostgreSQL and PostgreSQL support. If you need more information please contact us
Documentation at https://github.com/MigOpsRepos/pg_dbms_job#readme