8 Replies Latest reply: Feb 10, 2014 2:27 PM by user3191291 RSS

to get notification mails when a job gets failed

V11081985 Newbie
Currently Being Moderated

Hi Team


     I would like to schedule a job which notifies me and my team members when ever some particular jobs in a schema gets failed or disabled. I heard that there is oracle default program, 'DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION' which will do that. But i couldnt understand how to do that and how to get started with that. Can anyone plz guide me how to do that? Thanks in advance.


I am using Oracle 11g.





  • Correct Answers - 10 points
  • Helpful Answers - 5 points