9i - scheduled jobs not running

Hi all,

We are working with a third-party ERP system using Oracle databases, and a basic installation of it sets up some default scheduled jobs. We've never had a problem on 8i or 9i on NT, but after a recent 9.2.0.3 install on Solaris 8 we found that none of these jobs would run. They complete successfully if we use DBMS_JOB.SUBMIT and they re-schedule appropriately, but never actually run again.

JOB_QUEUE_PROCESSES is set to 9, and I can see the cjq0 process, along with j000 through j004. No errors in the alert log, no trace files anywhere. A co-worker set the hidden parameter _JOB_QUEUE_INTERVAL to 10 and bounced the db, and now the jobs are running correctly. After setting this parameter, I now see five entries for 'jobq slave wait' in v$session_wait, but these did not appear earlier.

Any ideas on why this wasn't working before? I thought that in 9i the job queue coordinator default interval was 5 seconds, and that the hidden parameter was only to be used if a smaller interval was needed.

Thanks in advance, Received on Sun Jul 20 2003 - 21:13:54 CDT