Get Email notification alerts through OEM / Scheduler

1)---First, we need to configure DBMS_SCHEDULER so that it knows how to send mail – where the mailserver is, and what the sender’s email address is. You can find out if these are configured with the following script: note that if they’re NULL, email will not work. This quick script will print out all of the attributes. In this example, we’re really only checking the EMAIL_SENDER, EMAIL_SERVER, and MAX_JOB_SLAVE_PROCESSES.

declare

  v_value varchar2(2000);

begin

  dbms_scheduler.get_scheduler_attribute('current_open_window',v_value);

  dbms_output.put_line('current open window '||v_value);