Méthode EnumNotifications (NotifyMethods, String)
Enumerates a list of notifications made by SQL Server Agent for a specified alert and for a specified notification method.
Espace de noms : Microsoft.SqlServer.Management.Smo.Agent
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public Function EnumNotifications ( _
notifyMethod As NotifyMethods, _
alertName As String _
) As DataTable
'Utilisation
Dim instance As [Operator]
Dim notifyMethod As NotifyMethods
Dim alertName As String
Dim returnValue As DataTable
returnValue = instance.EnumNotifications(notifyMethod, _
alertName)
public DataTable EnumNotifications(
NotifyMethods notifyMethod,
string alertName
)
public:
DataTable^ EnumNotifications(
NotifyMethods notifyMethod,
String^ alertName
)
member EnumNotifications :
notifyMethod:NotifyMethods *
alertName:string -> DataTable
public function EnumNotifications(
notifyMethod : NotifyMethods,
alertName : String
) : DataTable
Paramètres
- notifyMethod
Type : Microsoft.SqlServer.Management.Smo.Agent. . :: . .NotifyMethods
A NotifyMethods object value that specifies the notification method, such as e-mail, pager, or net-send.
- alertName
Type : System. . :: . .String
A String value that specifies the name of the alert.
Valeur de retour
Type : System.Data. . :: . .DataTable
A DataTable object value that contains a table of information about the notifications for the specified alert and notification method.
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. |