Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Guru's advice needed on dbms_job related question

Re: Guru's advice needed on dbms_job related question

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 08 Jul 2002 20:09:47 +0100
Message-ID: <3D29E37B.F23@yahoo.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US