Alert.EnumNotifications Method (String)
Enumerates a list of notification methods defined on the alert that are restricted to the specified operator.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Function EnumNotifications ( _
operatorName As String _
) As DataTable
'Usage
Dim instance As Alert
Dim operatorName As String
Dim returnValue As DataTable
returnValue = instance.EnumNotifications(operatorName)
public DataTable EnumNotifications(
string operatorName
)
public:
DataTable^ EnumNotifications(
String^ operatorName
)
member EnumNotifications :
operatorName:string -> DataTable
public function EnumNotifications(
operatorName : String
) : DataTable
Parameters
- operatorName
Type: System.String
A string value that specifies the name of the operator.
Return Value
Type: System.Data.DataTable
A DataTable object value that contains a table of information about the notifications defined on the alert.
Column |
Data type |
Description |
|---|---|---|
OperatorID |
Integer |
The operator ID value. |
OperatorName |
String |
The name of the operator. |
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. |
Examples
Scheduling Automatic Administrative Tasks in SQL Server Agent
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace