Notification on the failure of Oracle Scheduler job

ramukam

2018-07-11 22:49:32 UTC

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 => '***@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', '
***@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

Post by n***@gmail.com
In 11.2 https://oracle-base.com/articles/11g/scheduler-enhancements-11gr2
in 10.2 write your own.

Post by ramukam
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