JobStep.OnSuccessAction 속성

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

네임스페이스:  Microsoft.SqlServer.Management.Smo.Agent
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property OnSuccessAction As StepCompletionAction 
    Get 
    Set
‘사용 방법
Dim instance As JobStep 
Dim value As StepCompletionAction 

value = instance.OnSuccessAction

instance.OnSuccessAction = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public StepCompletionAction OnSuccessAction { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property StepCompletionAction OnSuccessAction {
    StepCompletionAction get ();
    void set (StepCompletionAction value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member OnSuccessAction : StepCompletionAction with get, set
function get OnSuccessAction () : StepCompletionAction 
function set OnSuccessAction (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 success.

주의

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 success, the next steps are determined by the OnSuccessAction property.

SQL Server 에이전트에서 자동 관리 태스크 예약

참고 항목

참조

JobStep 클래스

Microsoft.SqlServer.Management.Smo.Agent 네임스페이스

관련 자료

관리 태스크 자동화(SQL Server 에이전트)

sp_help_jobstep(Transact-SQL)