| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_job package
serge_l_at_my-deja.com wrote:
>
> My problem is: job sent with dbms_job package is failed but don't
> have a broken status. This is the reason why it rescheduled constantly
> (not 16 times!).
> I couldn't resolve the problem and decided to drop and recreate the
> dbms_job package with dbmsjob.sql script. After that package body is
> invalid and recompile not help me.
> 1.What i have to do for recreate the dbms_job package?
> 2.Why the failed job not broken.
> Thanks
> Serge Liberte
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
You need: dbmsjob.sql
and prvtjob.plb
for both package and package body...
With reference to the failure - does it actually raise an oracle error, ie, does the failures count go up...if your job "bombs out" but has an exception handler such that the procedure finishes "successfully" then the broken flag will not be set...
You can check the snp logs to see if oracle logged any errors with your job executions.
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Wed Jun 16 1999 - 10:17:54 CDT
 |
 |