Skip to Main Content

Database 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!

Add Email Job Notification via SQL Developer

Fritz-OCMar 20 2014 — edited Mar 20 2014

Hello,

I'm a novice in the Oracle Scheduler space and I have what is likely a novice question.  However, I'm thoroughly turned around after searching and would gladly welcome some help.

I'm using SQLdeveloper to utilize Oracle Scheduler within my schema.

A procedure has been successfully created.  The job which executes the procedure is also successfully configured.

Next I'd like to configure email notification for certain events.

I've found a number of posts regarding the ADD_JOB_EMAIL_NOTIFICATION procedure.

I.e., http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_sched.htm#ARPLS72277

However, I'm having trouble identifying how to get started implementing this within SQL Developer.

Can someone please help with how the ADD_JOB_EMAIL_NOTIFICATION can be implemented within SQL developer?

Another point I want to mention: in a previous prototype, I found a wizard to configure the email notification.  I'm not seeing that now.  Is there a wizard with SQL Developer in which this information can be configured? 

Extremely grateful for any help you can provide.

Thanks - Fritz

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2014
Added on Mar 20 2014
3 comments
4,420 views