- 28 Oct 2016
Setup sending E-Mail
This setup will configure the E-Mail sending in the commons schema.
This is important, for debugging jobs, database and some other notifications.
First, in the body from the COM_NOTIFIER search for 'c_smtp_server' and replace the CERN-server with this serer 'vml00a.acc.gsi.de'
The next step is to add a recipient (with your own address)
i_recipient_name => 'Max Musterman'
, i_recipient_email => 'm_Muster@gsi.de'
, i_recipient_sms_number => ''
, i_recipient_is_admin => 'Y'
The admin field is important for the notifications. Some errors-notifications send always the admins an E-Mail.
After this we test this insert, with the com_notifier.
bulk collect into l_recipients
from com_recipients cr
where cr.recipient_name = 'Max Musterman';
COM_NOTIFIER.NOTIFY_WITH_CLOB(l_recipients , 'TEST','TESTING');
The mail should be receive.
The next step is to setup the notification which the recipient want to receive.
In the table COM_EVENT_DEFINATION is the name of the events. Per example the Event_name 'INIT_FAILED' is taken.
for rec in (
where recipient_name like 'MAX%'
-- Register a notification with SMS enabled to these recipients whenever the
-- FAILED_MANAGE_PARTITION event occurs.
com_event_mgr.register_event_notification('INIT_FAILED', rec.recipient_id, 'Y');
when others then
-- If the recipient is already registered for this event, just ignore the exception, otherwise raise it
if not com_event_mgr.event_equals('RECIPIENT_OF_EVENT_EXISTS', sqlcode) then
After this update the recipients receive a mail when an error raises.