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 -> Guru's advice needed on dbms_job related question

Guru's advice needed on dbms_job related question

From: FC <flavio_at_tin.it>
Date: Mon, 08 Jul 2002 12:24:03 GMT
Message-ID: <DvfW8.54892$vm5.2026181@news2.tin.it>


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 Received on Mon Jul 08 2002 - 07:24:03 CDT

Original text of this message

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