-
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 ??
siva prakash
DBA
-
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
siva prakash
DBA
-
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 ) .
siva prakash
DBA
-
Thanks Prakash, I'll look into this as well.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|