3.54 ALL_SCHEDULER_NOTIFICATIONS

ALL_SCHEDULER_NOTIFICATIONS displays information about the E-mail notifications for the jobs accessible to the current user.

Related Views

• DBA_SCHEDULER_NOTIFICATIONS displays information about the E-mail notifications for all jobs in the database.

• USER_SCHEDULER_NOTIFICATIONS displays information about the E-mail notifications for the jobs owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
NOTIFICATION_OWNER	VARCHAR2(128)	NOT NULL	Owner of this notification This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
OWNER	VARCHAR2(128)	NOT NULL	Owner of the job this notification is for
JOB_NAME	VARCHAR2(128)	NOT NULL	Name of the job this notification is for
JOB_SUBNAME	VARCHAR2(128)		Subname of the job this notification is for
RECIPIENT	VARCHAR2(4000)	NOT NULL	E-mail address to send this E-mail notification to
SENDER	VARCHAR2(4000)		E-mail address to send this E-mail notification from
SUBJECT	VARCHAR2(4000)		Subject of the notification E-mail
BODY	VARCHAR2(4000)		Body of the notification E-mail
FILTER_CONDITION	VARCHAR2(4000)		Filter specifying which job events to send notifications for
EVENT	VARCHAR2(19)		Job event to send notifications for: JOB_STARTED JOB_SUCCEEDED JOB_FAILED JOB_BROKEN JOB_COMPLETED JOB_STOPPED JOB_SCH_LIM_REACHED JOB_DISABLED JOB_CHAIN_STALLED JOB_OVER_MAX_DUR
EVENT_FLAG	NUMBER	NOT NULL	Event number of the job event to send notifications for

See Also:

• "DBA_SCHEDULER_NOTIFICATIONS"

• "USER_SCHEDULER_NOTIFICATIONS"