Job.StartStepID 속성

Gets or sets the ID value of the first job step in the sequence to be executed.

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

구문

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

value = instance.StartStepID

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

속성 값

유형: System.Int32
An Int32 value that specifies the ID value of the first job step in the sequence.

주의

Microsoft SQL Server Agent job steps are identified by a user-defined, integer value. If no value is specified when you use SQL Server Management Objects (SMO) to create a job, job steps are given an identifier value when the job is added to the Jobs collection of a JobServer object.

By default, the StartStepID value is the value of ID property of the JobStep at the first ordinal position of the JobSteps collection property of the Job object.

The following code example creates a job and specifies that the job begins execution on step 4.

C#

Server srv = new Server("(local)");
Job jb = new Job(srv.JobServer, "Test Job");
jb.Create();
jb.StartStepID = 4;

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$jb = new-object Microsoft.SqlServer.Management.Smo.Agent.Job($srv.JobServer, "Test Job")
$jb.Create()
$jb.StartStepID = 4

참고 항목

참조

Job 클래스

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

관련 자료

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

sp_add_job(Transact-SQL)

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