John, Can you check to see if the job is broken.... (dba_jobs.broken & dba_jobs.failures). Thanks Chandra Pabba _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of John Dunn Sent: Thursday, April 12, 2007 9:26 AM To: oracle-l Subject: dba_jobs stopped working After years of working OK I have a problem with dba_jobs The job is on dba_jobs. There are adequate job_queue_proceses, but the code is not being run. Platform is oracle 9.2 on Solaris I have bounced database to no avail. Any one experienced this? John