Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Guru's advice needed on dbms_job related question
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
![]() |
![]() |