How to enable email notifications for Oracle Scheduler Chain Jobs? (Doc ID 1984807.1)

Last updated on DECEMBER 07, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 07-Dec-2016***

Goal

DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION procedure is used to get email notifications for regular Oracle Scheduler Jobs. However, this does not work for Chain Jobs which include one or more chain steps.

How can email notifications be enabled for Chain Jobs?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms