Software 42767 Published by

pg_dbms_job 1.5.0 has been released. pg_dbms_job is a PostgreSQL extension to create, manage and use Oracle-style DBMS_JOB scheduled job.



pg_dbms_job v1.5.0 released

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
Gnome_shell_screenshot_kwv4s1

pg_dbms_job v1.5.0 released