Forum Stats

  • 3,854,348 Users
  • 2,264,358 Discussions
  • 7,905,660 Comments

Discussions

Email notification for failed Jobs

598338
598338 Member Posts: 345
edited Sep 29, 2008 2:55PM in General Database Discussions
Hello,

We are using Oracle Database 10gR2 (10.2.0.2.0) on AIX 5.3

How can I setup email notifications for Failed Jobs ?

Here is what I did:

1. Setup email and Test mail (working)
2. Setup email address
3. Create schedule for notification
4. Create rule for Failed Job Count and select Send Email

But when the job fails, I do not get the email

I think I am missing something here.. Can you please help ?

Thanks a lot :)
Tagged:

Answers

  • 587671
    587671 Member Posts: 768
    edited Sep 25, 2008 4:15PM
    This link will assist you

    http://download.oracle.com/docs/cd/B19306_01/em.102/b40002/notification.htm#sthref1005

    Edited by: DarkFiBrE72 on Sep 25, 2008 9:15 PM
  • 587671
    587671 Member Posts: 768
    Did this answer your question ?
  • Pavan Kumar
    Pavan Kumar Member Posts: 11,904 Gold Crown
    Hi,

    Does up to the Below Three.. are they working properly..
    1. Setup email and Test mail (working)
    2. Setup email address
    3. Create schedule for notification (Does this working..try to test then go for next step)

    Coming to Step 4:-
    4. Create rule for Failed Job Count and select Send Email

    What do you mean by Failed Job Count .. ??
    what is the Logic you are following to find the latest Failed Job.??

    - Pavan Kumar N
  • 523473
    523473 Member Posts: 110
    Hi,
    I also have the same problem in my environment. I wish to get email when I have problem in execution of my rman job.
    I tried to execute example from tutorial link, but I have problem with procedure compilation, and also I can't call created procedure from Add PL/SQL Procedure window.
    Can anybody help me with this.

    Thanks,
    best regards Dragan.
This discussion has been closed.