Make sure you do not have any background jobs executing from default queue. You want to make sure nothing is blocking the rest of your background jobs. You also want to make sure the parameter JOB_QUEUE_PROCESSES is set to a value greater than zero. We use 10 for our Development and Test environments. If the JOB_QUEUE_PROCESSES parameter is set to zero background jobs will not execute and you’ll see everything sitting there waiting to be executed. We ran into this during one of our IFS 8 to IFS 10 upgrade test runs where we forgot to set the JOB_QUEUE_PROCESSES to 10 and the symptom was no executing background jobs. Below is a screenshot from our development environment. You’ll need your Oracle DBA to check the parameter and change it if necessary.
Make sure you do not have any background jobs executing from default queue. You want to make sure nothing is blocking the rest of your background jobs. You also want to make sure the parameter JOB_QUEUE_PROCESSES is set to a value greater than zero. We use 10 for our Development and Test environments. If the JOB_QUEUE_PROCESSES parameter is set to zero background jobs will not execute and you’ll see everything sitting there waiting to be executed. We ran into this during one of our IFS 8 to IFS 10 upgrade test runs where we forgot to set the JOB_QUEUE_PROCESSES to 10 and the symptom was no executing background jobs. Below is a screenshot from our development environment. You’ll need your Oracle DBA to check the parameter and change it if necessary.
As @william.klotz has mentioned, job_queue_processes parameter would be the first thing to check. The value that needs to be set for this parameter actually depends on the number of Batch Queues you have and the number of processes assigned for each queue.
The formula to calculate the minimum number of job_queue_processes needed is following:
“Value for JOB_QUEUE_PROCESSES” = "The sum of processes assigned for each queue” + “5 more processes for Oracle internal jobs”
Apart form this, go to Database Processes window in IEE and check whether there are processes for each queue. Initializing the queues would create these processes if they are not there.
If those check out okay, then the problem could be in the database scheduler, in which case restarting the database should work.
Make sure you do not have any background jobs executing from default queue. You want to make sure nothing is blocking the rest of your background jobs. You also want to make sure the parameter JOB_QUEUE_PROCESSES is set to a value greater than zero. We use 10 for our Development and Test environments. If the JOB_QUEUE_PROCESSES parameter is set to zero background jobs will not execute and you’ll see everything sitting there waiting to be executed. We ran into this during one of our IFS 8 to IFS 10 upgrade test runs where we forgot to set the JOB_QUEUE_PROCESSES to 10 and the symptom was no executing background jobs. Below is a screenshot from our development environment. You’ll need your Oracle DBA to check the parameter and change it if necessary.
Regards,
William Klotz
This was the root cause. Don't know how, but somehow this value got set to 0 in our Support environment. I’m not waiting for IT to confirm they know how to update that parameter. Thanks!
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
