JobStep.OnFailAction 属性

Gets or sets the action to take when the job step finishes execution with failure.

命名空间:  Microsoft.SqlServer.Management.Smo.Agent
程序集:  Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)

语法

声明
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property OnFailAction As StepCompletionAction 
    Get 
    Set
用法
Dim instance As JobStep 
Dim value As StepCompletionAction 

value = instance.OnFailAction

instance.OnFailAction = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public StepCompletionAction OnFailAction { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property StepCompletionAction OnFailAction {
    StepCompletionAction get ();
    void set (StepCompletionAction value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member OnFailAction : StepCompletionAction with get, set
function get OnFailAction () : StepCompletionAction 
function set OnFailAction (value : StepCompletionAction)

属性值

类型:Microsoft.SqlServer.Management.Smo.Agent.StepCompletionAction
A StepCompletionAction object value that specifies the action to take when the referenced job step finishes execution with a completion status of failure.

注释

When a job step finishes execution it has status specified by the CompletionResult object value. This is recorded in the LastRunOutcome property for the job step when it was last executed. If the job step completed with failure, the next steps are determined by the OnFailAction property.

示例

在 SQL Server 代理中计划自动管理任务

请参阅

参考

JobStep 类

Microsoft.SqlServer.Management.Smo.Agent 命名空间

其他资源

自动执行管理任务(SQL Server 代理)

sp_help_jobstep (Transact-SQL)