Oracle Failed Job
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Oracle Failed Job

  1. #1
    Join Date
    Aug 2002
    Posts
    43
    One of our Oracle jobs failed to run. Why was this not sent to the alert log?

  2. #2
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    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

  3. #3
    Join Date
    Aug 2002
    Posts
    43
    This is a user-defined job using the dbms_job package.

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    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

  5. #5
    Join Date
    Aug 2002
    Posts
    43
    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

  6. #6
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    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

  7. #7
    Join Date
    Aug 2002
    Posts
    43
    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
  •  


Click Here to Expand Forum to Full Width