Re: Backport of Email notifications for DBMS_SCHEDULER_JOBS in 11gR1
Date: Fri, 25 Jun 2010 09:15:34 +0100
Message-ID: <AANLkTikF6JyU2SFpo5ivbjGzT0vXnfKwMd8cs4VVNFrP_at_mail.gmail.com>
Hi,
Yes it is doable. Look at
http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/maildemo_sql.txt for some code to send email, also you have to look into setting up an ACL see MOS Note 557070.1 and then create a job that activates on an event from the queue sys.scheduler$_event_info.
It is a lot of code for some functionality that Oracle have included as part of the dbms_scheduler package (which I have not had a good look at yet).
Regards
Pete
On Fri, Jun 25, 2010 at 3:55 AM, Ravi Madabhushanam
<ravi.madabhushanam_at_gmail.com> wrote:
> Hello All,
> Recently I've requested the list to suggest me possible options for job
> scheduling and as per the recommendations by peers , I was able to configure
> Job Chains successfully and it worked really well. Thanks to everyone for
> helping me out.
> Now I would like to configure EMAIL notifications from DBMS_SCHEDULER when
> state of a JOB changes. This is a built-in feature in 11gR2 as part of
> standard DBMS_SCHEDULER package. But it seems this is not available in 11gR1
> .
> My requirement is to get alerts when a job completes success and/or failure.
> Do we have any built-in feature for this? Or do we have any best practice
> for achieving this requirement. Or any other workaround that could help me
> here?
> Thank you.
> Regards,
> Ravi.M
>
>
-- Regards Pete -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 25 2010 - 03:15:34 CDT