共用方式為


Alert.HasNotification Property

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 (in microsoft.sqlserver.smo.dll)

語法

'宣告
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

屬性值

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.

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

範例

How to: Create an Alert in Visual Basic .NET

執行緒安全性

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.

平台

開發平台

如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。

目標平台

如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。

請參閱

參考

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

其他資源

Scheduling Automatic Administrative Tasks in SQL Server Agent
自動化管理工作 (SQL Server Agent)
sp_add_alert (Transact-SQL)