Monday, February 22, 2010

DAC email does not work as expected (Notification levels are ignored)

I have set up DAC to send emails to users (As per my previous entry- http://obieetips.blogspot.com/2010/02/dac-email-notification.html ), whenever the data load completes.
However, I have two problems.

1.
The email notifications do not work as expected.
Level 1 sends only failure emails but not success emails.
This is an open bug with oracle and the solution is to use Level 5 for the moment.
Level 5 works as expected- which is to send 'Running' as well as 'Failure'/'Success' emails, everytime an ETL load is started and completed.
This can be quite overwhelming for the users.
A bug already exists for this issue so we are eagerly awaiting a patch.
BUG:9133839 - DAC IGNORES NOTIFICATION LEVELS DEFINED FOR EMAIL RECIPIENTS

2.
The above email notifications are a bit too verbose for users who have limited time to check on the ETL status. Due to this I asked Oracle support if there was a way to change the email content so as to limit the amount of information to be sent over email to 'non-developers'. Unfortunately there is no way to modify the emails in version 10.1.3.4. It is part of the upcomign enhancements. I am looking forward to 11g.
ER is 7425308 / 8989562

Please let me know if you have any workarounds that we may be able to try or have any more updates on the latest from Oracle.

Thanks for reading,
Anisha

1 comment:

  1. Hi,
    I am having similar problem where i can send test email notification fine, however when the etl job completes the e-mail i snot sent to the users. I have set the level to 5. if you have any suggestions i will be very great full.

    Thanks,

    Aco

    ReplyDelete