다음을 통해 공유


Alert.HasNotification 속성

Gets the number of SQL Server Agent operators that are assigned to receive notification when the alert is fired.

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

구문

‘선언
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property HasNotification As Integer 
    Get
‘사용 방법
Dim instance As Alert 
Dim value As Integer 

value = instance.HasNotification
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int HasNotification { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property int HasNotification {
    int get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member HasNotification : int
function get HasNotification () : int

속성 값

유형: System.Int32
An Int32 value that specifies the number of operators to be notified when the alert is fired.

주의

SQL Server Agent attempts to notify one or more operators when an alert is raised. A notification is sent based on both assignment and operator availability. The days and hours that a SQL Server Agent operator is available are set for each operator. The HasNotification property reports the total number of operators assigned to receive a notification, not the number of operators that actually receive a notification for any particular occurrence of the event raising the alert.

SQL Server 에이전트에서 자동 관리 태스크 예약

참고 항목

참조

Alert 클래스

Microsoft.SqlServer.Management.Smo.Agent 네임스페이스

관련 자료

관리 태스크 자동화(SQL Server 에이전트)

sp_add_alert(Transact-SQL)