아티클
04/01/2012

EnumNotifications 메서드 (NotifyMethods)

Enumerates a list of notifications made by SQL Server Agent for job completion and for raised alerts for a specified notification type.

네임스페이스: Microsoft.SqlServer.Management.Smo.Agent
어셈블리: Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
Public Function EnumNotifications ( _
    notifyMethod As NotifyMethods _
) As DataTable
‘사용 방법
Dim instance As [Operator]
Dim notifyMethod As NotifyMethods
Dim returnValue As DataTable

returnValue = instance.EnumNotifications(notifyMethod)

public DataTable EnumNotifications(
    NotifyMethods notifyMethod
)

public:
DataTable^ EnumNotifications(
    NotifyMethods notifyMethod
)

member EnumNotifications : 
        notifyMethod:NotifyMethods -> DataTable

public function EnumNotifications(
    notifyMethod : NotifyMethods
) : DataTable

매개 변수

notifyMethod
유형: Microsoft.SqlServer.Management.Smo.Agent. . :: . .NotifyMethods
A NotifyMethods object value that specifies the notification method, such as e-mail, pager, or net-send.

반환 값

유형: System.Data. . :: . .DataTable
A DataTable object value that contains a table of information about the notifications and the associated jobs and alerts for the specified notification type.

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 email 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.