This discussion is archived
3 Replies Latest reply: Aug 28, 2013 1:29 PM by cathy.collins RSS

EMail Notification for Chain Job in standard edition one

842332 Newbie
Currently Being Moderated
Hello All,

Oracle version :11.2.0.2 standard edition one

I'm trying to enable Email Notification for Chain Jobs, Jobs are running successfully, but i'm not getting email Notification
can you please help me in finding out what i have missed / where i went wrong.

i have done necessary SMPT setting in the Enterprise manager and i'm receiving test email from EM.

Below are steps followed:
1) i have created two Program
2)Add this program to a Chain
3)Created a Scheduler Job using this chain
4)Enable Email notification

Code for Email Nitrification:

BEGIN

DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION (

job_name => 'ChainJob',

recipients => 's.sankar@test.com',

sender => 'sankars@test.com',

subject => 'Scheduler Job Notification-%job_owner%.%job_name%-%event_type%',

body => '%event_type%',

events => 'JOB_FAILED, JOB_BROKEN,JOB_DISABLED,JOB_SUCCEEDED,JOB_SCH_LIM_REACHED');

END;

/

exec dbms_scheduler.set_scheduler_attribute('email_server','smtp.test.com')

exec dbms_scheduler.set_scheduler_attribute('email_sender','sankars@test.com')

Thanks
sankar

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points