Oracle 视图 ALL_SCHEDULER_NOTIFICATIONS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_SCHEDULER_NOTIFICATIONS用于存储和检索调度器通知信息，它还用于提供Oracle调度器活动的信息。此视图提供下表中的列：
OWNER：表示通知拥有者的用户名
NOTIFICATION_NAME：表示通知的名称
ADDRESS：表示要发送的通知的Internet地址的类型
PROTOCOL：表示通知传输协议名称（如HTTP，HTTPS或FTP）
ADDRESS_VALUE：表示发送通知的Internet地址
JOB_NAME：表示发送通知任务的名称
要使用此视图，您需要在SQL * Plus中执行以下操作：
SELECT *
FROM ALL_SCHEDULER_NOTIFICATIONS;
该语句将检索出系统中所有调度器通知信息。您可以通过添加WHERE子句来仅检索特定的信息，例如：
SELECT *
FROM ALL_SCHEDULER_NOTIFICATIONS
WHERE JOB_NAME = ‘JOB1’;
该语句将检索出具有名称“JOB1”的调度器任务发送的通知的所有信息。
官方英文解释
ALL_SCHEDULER_NOTIFICATIONS displays information about the E-mail notifications for the jobs accessible to the current user.
Related Views
-
DBA_SCHEDULER_NOTIFICATIONSdisplays information about the E-mail notifications for all jobs in the database. -
USER_SCHEDULER_NOTIFICATIONSdisplays information about the E-mail notifications for the jobs owned by the current user. This view does not display theOWNERcolumn.
| 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:
-
“DBA_SCHEDULER_NOTIFICATIONS”
-
“USER_SCHEDULER_NOTIFICATIONS”
