79785917

Date: 2025-10-08 23:31:05
Score: 0.5
Natty:
Report link

I know I'm late to the thread here, but what you really want is a native Oracle Advanced Queuing (AQ) object (supports FIFO, LIFO, etc.). Queuing has been supported natively in the Oracle database for decades. Learn more here:

You would create an AQ queue and associate that AQ object to your DBMS_SCHEDULER job. Then you just enqueue a messages to trigger and event and AQ kicks off the job. Here's the Oracle documentation:

Reading your use case, had you known about Oracle's native AQ feature, you might not have needed to create the DBMS_SCHEDULER artifacts at all. Your process the submit jobs would instead only need to "enqueue messages" and the setup of the AQ object determine how you want things run (1 at time, 50 at a time, LIFO, FIFO, etc.). Here's a great Ask Tom posting from back in 2012 that demonstrates the full setup with code:

Note: the URLs I cited above are for version 19c of the Oracle database. Just change the number in the URL from 19 to 23 to go the 23ai version which has many more enhancements for feature you'll never get around to using because there are so many!

Reasons:
  • Long answer (-1):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Roll Tide