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, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Beth Wells INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
