Re: Notification on the failure of Oracle Scheduler job

I followed the steps as described in 11gR2 document but for some reason it didn't work for me.

Here is what I tried.
Job_name: SABATOFWDATATRANSFER_JOB
Owner: db_user1

• Executed it as db_user1 user BEGIN DBMS_SCHEDULER.add_job_email_notification ( job_name => 'SABATOFWDATATRANSFER_JOB', recipients => 'mandaa1_at_domain.com', events => 'job_failed, job_broken, job_disabled, job_sch_lim_reached'); END; /
• Executed this as sysdba BEGIN DBMS_SCHEDULER.set_scheduler_attribute('email_server', 'postman.domain.com '); DBMS_SCHEDULER.set_scheduler_attribute('email_sender', ' oracle_at_server.domain.com'); END; / NAME TYPE VALUE ------------------------------------ -----------

  ---

  smtp_out_server string postman.domain.com

--Disabled the job SABATOFWDATATRANSFER_JOB

• Waited for the job to run from the scheduler
• Didn't receive any email indicating that the job was disabled.

Any help will be appreciated.

Thanks,
Ashoke

On Tue, May 22, 2018 at 1:09 PM, <niall.litchfield_at_gmail.com> wrote:

> In 11.2 https://oracle-base.com/articles/11g/scheduler-enhancements-11gr2
> in 10.2 write your own.
>
> On Tue, 22 May 2018, 16:33 ramukam, <ramukam1983_at_gmail.com> wrote:
>
>> Dear List members,
>>
>> We would like to get notified when a Oracle Scheduler job fails. Our
>> databases are on 10.2.0.4 and 11.2.0.4.
>>
>> Could you please advise.
>>
>> Thanks,
>> Ashoke
>>
>

--
http://www.freelists.org/webpage/oracle-l