One of our Oracle jobs failed to run. Why was this not sent to the alert log?
Printable View
One of our Oracle jobs failed to run. Why was this not sent to the alert log?
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 ??
This is a user-defined job using the dbms_job package.
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
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
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 ) .
Thanks Prakash, I'll look into this as well.