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: sybrandb <sybrandb_at_gmail.com>
Date: 17 Jul 2006 07:59:50 -0700
Message-ID: <1153148390.775117.18260@b28g2000cwb.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




The answer is probably version dependent.
In 9i and before you can find the error in the *snp*.trc files on the
server.



Hth

-- 
Sybrand Bakker
Senior Oracle DBA


Received on Mon Jul 17 2006 - 09:59:50 CDT












Original text of this message













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