Alert.HasNotification Property
Gets the number of SQL Server Agent operators that are assigned to receive notification when the alert is fired.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property HasNotification As Integer
Get
'Usage
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
Property Value
Type: System.Int32
An Int32 value that specifies the number of operators to be notified when the alert is fired.
Remarks
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.
Examples
Scheduling Automatic Administrative Tasks in SQL Server Agent
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace