Re: Oracle jobs not running. Help

From: Harald Maier <maierh_at_myself.com>
Date: Tue, 16 Sep 2003 17:49:21 +0200
Message-ID: <m3llso3f9a.fsf@ate.maierh>

natalia.poggi_at_spm.com.ar (Nat) writes:

> Since our last cold backup something with the dbms_jobs seems to be
> wrong.

> I cannot figure what. All de jobs are queued in the dba_jobs table
> with broken = 'N' and failures = null. But for some reason they do
> not run. They just stay there waiting for the ora_snpXX_sid to picke
> them up!!!
>

You might look into the trace files in the directory where the 'background_dump_dest' initialization parameter points to. There you should find a error message.

Harald Received on Tue Sep 16 2003 - 10:49:21 CDT