3 Replies Latest reply: Aug 28, 2013 3:29 PM by cathy.collins RSS

    EMail Notification for Chain Job in standard edition one

    842332
      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