Email notification for failed Jobs

598338

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

587671

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

Did this answer your question ?

Pavan Kumar

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

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.