JobStep.CommandExecutionSuccessCode 속성

Gets or sets the process exit code from a command shell process executed as a job step.

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

구문

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

value = instance.CommandExecutionSuccessCode

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

속성 값

유형: System.Int32
A Int32 value that specifies the command execution success code; 0 is success, and 1 is failure.

주의

A job step that executes a command shell process relies on the process exit code to determine the success or failure of the job step. Set the CommandExecutionSuccessCode property to the successful return code of a command shell process to enable logic and notifications based on the success or failure of the job step.

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

참고 항목

참조

JobStep 클래스

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

관련 자료

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

sp_help_jobstep(Transact-SQL)