Oracle Failed Job

[dba_essex]

One of our Oracle jobs failed to run. Why was this not sent to the alert log?

[prakashs43]

Asper my knowledge it is not necessary to writye all the errors to alert logs . for certail messages to come in alert log we need to set the appropriate parameter in init.ora file .
pls let me know which Oracle failed jobs u are talking about . is this a user defined job or default background process ??

[dba_essex]

This is a user-defined job using the dbms_job package.

[prakashs43]

To get the details of the failure .
try any one of this .

SELECT JOB FROM DBA_JOBS WHERE BROKEN = 'Y';

SELECT FAILURES, JOB FROM DBA_JOBS;

Hope this helps

[dba_essex]

I do know that the job has failed but I was wondering why it wasn't sent to the alert log. I guess I'll write a script to check the broken, failures for all jobs.

Thanks

[prakashs43]

I don't think whether User defined jobs are ever shown in alert log file .
i just remember that there are some initialisation parameters, which will let DBMS_jobs failed display in alert log . ( by setting SNP process and Job queing ) .

[dba_essex]

Thanks Prakash, I'll look into this as well.