Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
General Database Discussions
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jul 24, 2009 12:07 PM by
dbms_scheduler (sending email f a failed job occured)
Jul 14, 2009 5:20 AM
how do i
1) configure a scheduler job to automatically send me an email if the scheduler job failed due to some reason as stated in (user_scheduler_log).
i have read the administrator guide on scheduler events
and i believe that i have to somehow enqueue the event and dequeue it.
if that is the case, wouldn't i have to have another application/job running that monitor this event queue 24/7 (so that if its sees any error event, it will send an email to me)
then wouldnt i have an infinite loop?
a job to monitor the event, and also subscribe this job to another queue so that another job will monitor this queue and the list goes on.. ?
2) in my application, i have some error handling exception case whereby i need to send an email.
i understand i can do this with UTL_MAIL package.
what else or information do i need to get (or convey to the system admin) in the server (for the configuring of email) - i am a nut in emails server.
This content has been marked as final.
Show 1 reply
Re: dbms_scheduler (sending email f a failed job occured)
Jul 24, 2009 12:07 PM
in response to
1) Oracle released a nice package for that:
2) If you have an smtp server you are ready to go. The rest of the package is very straight forward.