[Home] [Help] [Dependency Information]
Object Name: | USER_SCHEDULER_NOTIFICATIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All e-mail notifications for jobs owned by the current user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOB_NAME | VARCHAR2 | (128) | Yes | Name of the job this notification is for |
JOB_SUBNAME | VARCHAR2 | (128) | Subname of the job this notification is for | |
RECIPIENT | VARCHAR2 | (4000) | Yes | 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 | |
EVENT_FLAG | NUMBER | Yes | Event number of job event to send notifications for |
Cut, paste (and edit) the following text to query this object:
SELECT JOB_NAME
, JOB_SUBNAME
, RECIPIENT
, SENDER
, SUBJECT
, BODY
, FILTER_CONDITION
, EVENT
, EVENT_FLAG
FROM SYS.USER_SCHEDULER_NOTIFICATIONS;
|
|
|