Re: job failures of dbms_jobs


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

.

Relevant Pages

  • Re: job failures of dbms_jobs
    ... barraboombarrabin wrote: ... Best Regards ... This is why you should be familiar with the alert log and the ...
    (comp.databases.oracle.server)
  • Re: Separate Compilation in Programming Languages
    ... And that is exactly analogous a change to an Ada package spec ... exactly the same as changing an Ada package spec. ... A dependent unit, when the specification ... If the public signatures do not change, ...
    (comp.lang.ada)
  • Re: very simple question vhd files
    ... more times than not, it will), I put the package and package body that ... needs to change as well so separating the package into a separate file ... to update at least some of the dependent changes since they are ... options to only compile certain types of units found in the file. ...
    (comp.lang.vhdl)
  • Re: Separate Compilation in Programming Languages
    ... everything that is dependent on this specification is also ... can move those dependencies to the package body. ... OK, so you like having textually separate spec and body, ... One advantage of Ada over some languages is that the ...
    (comp.lang.ada)
  • Re: dip Notions 2 Major Errors
    ... there is an inversion - at the cost of another package having ... >like with like and see inversion. ... and another package has to become dependent on it in order to ... The usageInterface is intimately bound to the user. ...
    (comp.object)