共用方式為


Alert.Severity 屬性

Gets or sets the error message severity level that causes the alert to be raised.

命名空間:  Microsoft.SqlServer.Management.Smo.Agent
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property Severity As Integer 
    Get 
    Set
'用途
Dim instance As Alert 
Dim value As Integer 

value = instance.Severity

instance.Severity = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int Severity { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property int Severity {
    int get ();
    void set (int value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member Severity : int with get, set
function get Severity () : int 
function set Severity (value : int)

屬性值

型別:System.Int32
An Int32 value that specifies the error message severity.

備註

A SQL Server Agent alert is raised when a Microsoft SQL Server process raises a specific error or an error of a specific severity level. Setting the Severity property of an Alert object associates an alert with a specific SQL Server error message severity level.

Setting both the Severity and MessageID properties of an Alert object attempts to associate an alert with both an error message severity level and an error message, which causes an exception.

範例

使用 SQL Server Agent 排程自動管理工作

請參閱

參考

Alert 類別

Microsoft.SqlServer.Management.Smo.Agent 命名空間

其他資源

自動化管理工作 (SQL Server Agent)

sp_add_alert (Transact-SQL)