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
Microsoft.SqlServer.Management.Smo.Agent Namespace