Share via


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.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

Alert Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_add_alert (Transact-SQL)