[Home] [Help] [Dependency Information]
Object Name: | CDB_SCHEDULER_NOTIFICATIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All job e-mail notifications in the database in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the job this notification is for |
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 | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, JOB_NAME
, JOB_SUBNAME
, RECIPIENT
, SENDER
, SUBJECT
, BODY
, FILTER_CONDITION
, EVENT
, EVENT_FLAG
, CON_ID
FROM SYS.CDB_SCHEDULER_NOTIFICATIONS;
SYS.CDB_SCHEDULER_NOTIFICATIONS does not reference any database object
SYS.CDB_SCHEDULER_NOTIFICATIONS is referenced by following:
|
|
|