Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Guru's advice needed on dbms_job related question
FC wrote:
>
> Hello folks,
> speaking 8.1.7.0.0. Win2000wise, does anybody know where I can find
> information about errors occurring while running a job submitted via
> dbms_job.submit ?
> I am specifically looking for any error codes that might have prevented the
> job from completing.
> I checked in dba_jobs and user_jobs views, but they merely report if a job
> is broken, I need some more details.
> I'd like to know also when the job completed, but it seems that the job
> entry is removed from the job queue once it's finished.
> Theoretically I could send a message using dbms_alert, but I am having
> problems using this package from within scheduled jobs, anybody's aware of
> any restrictions on this kind of usage ?
>
> Thanx!
> Flavio
A job that fails will write information to both the alert log and a trace file.
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Mon Jul 08 2002 - 14:09:47 CDT