Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_SCHEDULER_NOTIFICATIONS

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

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the job this notification is for
JOB_NAME VARCHAR2(30) NOT NULL Name of the job this notification is for
JOB_SUBNAME VARCHAR2(30)   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