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 theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of this notification |
|
|
|
Owner of the job this notification is for |
|
|
|
Name of the job this notification is for |
|
|
|
Subname of the job this notification is for |
|
|
|
E-mail address to send this E-mail notification to |
|
|
|
E-mail address to send this E-mail notification from |
|
|
|
Subject of the notification E-mail |
|
|
|
Body of the notification E-mail |
|
|
|
Filter specifying which job events to send notifications for |
|
|
|
Job event to send notifications for:
|
|
|
|
Event number of the job event to send notifications for |
See Also: