Automatic Concurrent Queue Management

I will start this blog with one of my recent development for my company.

Things are gonna be of varied nature here and thus dont let the first Ebusiness suite post fool you to think that this is going to be purely E Business Suite Blog.

We have had running issue where every time some or few long running jobs clog the standard manager queue and thus making all the remaining jobs pending and wait till they complete. Segregation of queues is always recommended for different nature of jobs, but not many client sites follow this.

Another way would be to bump up the queue temporarily and thus let others get executed (who were pending so far) also if possible automate this based on load and thus not worry about the clogs at all

Here is the script we wrote and scheduled it using dbms_scheduler to check every 3 minutes, lot of AI can be built in it, but for now it does the job for us

Your comments will help inspire me to help more of our folks with this Blog