CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloperdbms-scheduler
kushi
kushi

Reputation: 27

Sending notification emails when the scheduled job fails in Oracle

I have 4 scheduled jobs,if any of these job fails we have to send alert email regarding job failure to the concerned recipients.how can we do this in Oracle SQL Developer. Can we do this using DBMS_SCHEDULER? What is NOC Alert?

Upvotes: 2

Views: 6433

Answers (1)

milheiros
milheiros

Reputation: 619

Yes, DBMS_SCHEDULER jobs can be configured to send an email after certain events occur. For example:

-- Configure scheduler emails --
BEGIN
  DBMS_SCHEDULER.set_scheduler_attribute('email_server', 'smtp.mycompany.com:25');
  DBMS_SCHEDULER.set_scheduler_attribute('email_sender', '[email protected]');
END;
/

-- Create a job here --
...

-- Configure the job to send emails on failures: 
BEGIN
 DBMS_SCHEDULER.add_job_email_notification (
  job_name   =>  'test_notification_job',
  recipients =>  '[email protected]',
  events     =>  'job_failed');
END;
/

See ORACLE-BASE for more examples. And see the manual for an extremely thorough description of all the DBMS_SCHEDULER options.

Upvotes: 3

Related Questions