Re: Backport of Email notifications for DBMS_SCHEDULER_JOBS in 11gR1
- From: Ravi Madabhushanam <ravi.madabhushanam@xxxxxxxxx>
- To: pjhoraclel@xxxxxxxxx
- Date: Fri, 25 Jun 2010 16:29:26 +0530
Wow. Thats great.
Thanks a lot Pete. Let me try implementing this and will let you know how it
goes.
~Ravi.M
On Fri, Jun 25, 2010 at 1:45 PM, Peter Hitchman <pjhoraclel@xxxxxxxxx>wrote:
> 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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
