Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Send a Failure Email Notification After Load Plan execution in ODI 11g

User_PSI4XMar 26 2015 — edited Apr 1 2015

Hi Experts,

Greetings!

I am trying to send an email if any of the step fails during Load Plan execution. Irrespective of the failed object, only 1 email should be sent to the Administrator. I unable to do this. Mails are getting sent for the no of times the no of object fails. For eg if 10 out of 100 steps fails, 10 emails are getting sent. I need to send only 1 email.

I am using ODISendMail.

I have tried various combinations however, all in Vain.

For instance:

root step --> Exeception Step (Send Failure Email) and Execption behaviour (Run Exception and Ignore). Using this because, I dont want to stop the load plan on the step failure.

Interface1: Exeception Step (Blank) and Execption behaviour (Run Exception and Ignore).

Interface2: Exeception Step (Blank) and Execption behaviour (Run Exception and Ignore).

Exception not getting executed.

Please help.

Regards,

Andy

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 29 2015

Added on Mar 26 2015

#business-intelligence-applications, #data-integrator, #system-management-and-integration

9 comments

2,355 views