PG_DBMS_JOB – PostgreSQL extension for Oracle DBMS_JOB compatibility

Neat. Every Oracle shop from 2001 onward has tons of these jobs. Some of the funkiest apps were ones that used it as a deferred task queue as, IIRC, submitting a job was done transactionally with the rest of your unit of work.<p>If you think DBMS_JOB is great, then you’ll love UTL_TCP! What better way to build an unsupportable nightmare than arbitrary TCP sockets directly from PL&#x2F;SQL stored procedures: <a href="https:&#x2F;&#x2F;docs.oracle.com&#x2F;cd&#x2F;E18283_01&#x2F;appdev.112&#x2F;e16760&#x2F;u_tcp.htm" rel="nofollow">https:&#x2F;&#x2F;docs.oracle.com&#x2F;cd&#x2F;E18283_01&#x2F;appdev.112&#x2F;e16760&#x2F;u_tcp...</a>

Have seen a ton of Oracle databases with DBMS_JOB. Great thought and contribution by MigOps.

Is this the sort of thing that will see Oracle sending a cease and desist for them feeling infringed on their copyright and IP? They must not like their vendor lock in being affected and people discovering this better, more affordable alternative.

This is a brilliant mission. Postgres is commoditising the database in an amazing way.

As it is a full compatibility to Oracle&#x27;s DBMS_JOB, it must help a lot while migrating from Oracle to PostgreSQL.