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