Re: Alert log file

Robert Scheer wrote:
> Hi Brian and Frank.
>
> I can run the job manually and it works. This job runs every minute, to
> serve an application with some data. Suddenly, a feature of the
> application stopped working and I saw that it was because of the job
> being broken. What I need is to know if Oracle logged anywhere the
> error that stopped the job. Sure, the job found an strange situation
> that caused the error, but I don't know why and till now I could not
> reproduce this error. When a job gets broken, nothing is logged?
>
> Thanks,
> Robert Scheer

Unless you take specific action, the above description is not likely to produce any logs of what went wrong.

When you say you have a "job", is this something scheduled through DBMS_JOBS or DBMS_SCHEDULER? Or is this job scheduled through something else?

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown