다음을 통해 공유

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)