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: job failures of dbms_jobs

Re: job failures of dbms_jobs

From: <fitzjarrell_at_cox.net>
Date: 17 Jul 2006 11:19:55 -0700
Message-ID: <1153160391.854544.174440@35g2000cwc.googlegroups.com>

barraboombarrabin wrote:
> Is there any data dictionary view that displays the reason why a
> package
> scheduled and running via dbms_job has failed ?
>
> Best Regards
>
>
> Manav

No. This is why you should be familiar with the alert log and the information it provides. You will find the errors generated by such jobs there, as well as trace file names where additional information for those errors can be found.

David Fitzjarrell Received on Mon Jul 17 2006 - 13:19:55 CDT

Original text of this message

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