Metodo Operator.EnumNotifications
Enumerates a list of notifications made by SQL Server Agent for job completion and for raised alerts.
Spazio dei nomi Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Sintassi
'Dichiarazione
Public Function EnumNotifications As DataTable
'Utilizzo
Dim instance As [Operator]
Dim returnValue As DataTable
returnValue = instance.EnumNotifications()
public DataTable EnumNotifications()
public:
DataTable^ EnumNotifications()
member EnumNotifications : unit -> DataTable
public function EnumNotifications() : DataTable
Valore restituito
Tipo: System.Data.DataTable
A DataTable object value that contains a table of information about the notifications and the associated jobs and alerts.
Column |
Data type |
Description |
---|---|---|
AlertID |
Integer |
The alert ID value. |
AlertName |
String |
The name of the alert. |
UseEmail |
Boolean |
A Boolean value that specifies whether the notification is instructed to use e-mail to inform the operator. |
UsePager |
Boolean |
A Boolean value that specifies whether the notification is instructed to use a pager service to inform the operator. |
UseNetSend |
Boolean |
A Boolean value that specifies whether the notification is instructed to use a net send message to inform the operator. |
HasEmail |
Boolean |
A Boolean value that specifies whether the operator can receive e-mail notifications. |
HasPager |
Boolean |
A Boolean value that specifies whether the operator can receive pager notifications. |
HasNetSend |
Boolean |
A Boolean value that specifies whether the operator can receive net-send notifications. |
Esempi
Pianificazione delle attività amministrative automatiche in SQL Server Agent
Vedere anche
Riferimento
Spazio dei nomi Microsoft.SqlServer.Management.Smo.Agent
Altre risorse
Automatizzazione delle attività amministrative (SQL Server Agent)