JobStep.OnFailStep Property
Gets or sets the job step that is executed after the referenced job step finishes execution with a completion status of failure.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property OnFailStep As Integer
Get
Set
'Usage
Dim instance As JobStep
Dim value As Integer
value = instance.OnFailStep
instance.OnFailStep = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int OnFailStep { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property int OnFailStep {
int get ();
void set (int value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member OnFailStep : int with get, set
function get OnFailStep () : int
function set OnFailStep (value : int)
Property Value
Type: System.Int32
An Int32 value that specifies the ID value of the job step that is executed after the referenced job step finishes with failure.
Examples
Scheduling Automatic Administrative Tasks in SQL Server Agent
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace