Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Enumerates a list of notifications made by SQL Server Agent for the specified alert.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Function EnumNotifications ( _
alertName As String _
) As DataTable
'Usage
Dim instance As [Operator]
Dim alertName As String
Dim returnValue As DataTable
returnValue = instance.EnumNotifications(alertName)
public DataTable EnumNotifications(
string alertName
)
public:
DataTable^ EnumNotifications(
String^ alertName
)
member EnumNotifications :
alertName:string -> DataTable
public function EnumNotifications(
alertName : String
) : DataTable
Parameters
- alertName
Type: System.String
A string value that specifies the name of the alert.
Return Value
Type: System.Data.DataTable
A DataTable object value that contains a table of information about the notifications for the specified alert.
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. |
Examples
Scheduling Automatic Administrative Tasks in SQL Server Agent
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace