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
Public ReadOnly Property HasNotification As Integer
public int HasNotification { get; }
public:
property int HasNotification {
    int get ();
}
/** @property */
public int get_HasNotification ()
public function get HasNotification () : int

Eigenschaftswert

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

Hinweise

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.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.

Beispiel

How to: Create an Alert in Visual Basic .NET

Threadsicherheit

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Plattformen

Entwicklungsplattformen

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Zielplattforme

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Siehe auch

Verweis

Alert Class
Alert Members
Microsoft.SqlServer.Management.Smo.Agent Namespace

Andere Ressourcen

Scheduling Automatic Administrative Tasks in SQL Server Agent
Automatisieren administrativer Tasks (SQL Server-Agent)
sp_add_alert (Transact-SQL)