This content has been marked as final. Show 7 replies
Actually, it turned out that I needed to create and configure a network ACL.
I did not know about that part.
I created a method send_mail according to
Executing that method reported the error message that led me to the cause of the problem.
The ACL part is described towards the end of [http://matthiashoys.wordpress.com/2012/04/27/ora-06502-ora-24247-calling-utl_mail-from-oracle-11gr2/]
Ooops - jumped the gun.
Emails are still not being sent.
I am able to send emails using the send_mail procedure I created.
Now I have this test setup:
Job MAILTEST is calling the stored procedures SEND_MAIL with the same parameters (Sender, recipient, smtp-server) as the scheduler in order to send out a test message.
That email does* get delivered. However, the job notification is still not* being sent, although all events are enabled:
The job status in ALL_SCHEDULER_JOB_RUN_DETAILS shows "SUCCEEDED".
Any idea what is wrong?
Where can I check logs regarding this?
Edited by: 975222 on 21.03.2013 16:55
Edited by: 975222 on 21.03.2013 16:56
The job does not have to raise errors, but it seems like in order to send JOB_SUCCEEDED and JOB_STARTED notifications, those two events need to be raised.
I executed the below command in order to enable raise events for all events:
sys.dbms_scheduler.set_attribute( name => '"DN_DWH_CATALOG"."MAILTEST"', attribute => 'raise_events', value => '511');
and afterwards I did receive the two notifications just like you said.
Then I called this command:
sys.dbms_scheduler.set_attribute( name => '"DN_DWH_CATALOG"."MAILTEST"', attribute => 'raise_events', value => '0');
to disabled raise_events for all events and restarted my job => no more notifications.
Up to now, I thought just enabling notifications for a certain event type for the job would send out emails independent on the raise_event settings of the job.
Hope this is clearer now...