Re: Notification on the failure of Oracle Scheduler job

  • From: ramukam <ramukam1983@xxxxxxxxx>
  • To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • Date: Wed, 11 Jul 2018 17:49:32 -0500

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@xxxxxxxxxx',
  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@xxxxxxxxxxxxxxxxx');
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@xxxxxxxxx> 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@xxxxxxxxx> 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


Other related posts: