• Article

Alert.Severity Property

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

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property Severity As Integer
    Get
    Set
'Usage
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)

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.