We had this problem with 9.2.0.1 on Solaris. We applied the 9.2.0.6 patch and that fixed it. For no apparent reason the dba_jobs used to stop. HTH GovindanK On Thu, 12 Apr 2007 18:37:22 +0200, "Maxim Demenko" <mdemenko@xxxxxxxxx> said: > John Dunn schrieb: > > 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 > > > Look up Note 3427424.8 , maybe you hit this bug. > Best regards > > Maxim > -- > //www.freelists.org/webpage/oracle-l > > -- //www.freelists.org/webpage/oracle-l