Alert.Severity Property

Article
07/16/2015

Applies To: SQL Server 2016 Preview

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

Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.Matrix)]
public int Severity { get; set; }

public:
[SfcPropertyAttribute(SfcPropertyFlags::None | SfcPropertyFlags::Standalone | SfcPropertyFlags::Matrix)]
property int Severity {
    int get();
    void set(int value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.Matrix)>]
member Severity : int with get, set

<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Matrix)>
Public Property Severity As Integer

Property Value

Type: System.Int32

An Int32 value that specifies the error message severity.

Remarks

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.

Examples

Legacy Code Example

Scheduling Automatic Administrative Tasks in SQL Server Agent