AddStepToJob Method

SQL-DMO

SQL-DMO

AddStepToJob Method

The AddStepToJob method configures the referenced Microsoft® SQL Server™ Agent job by appending the job step defined by the JobStep object specified.

Applies To
Job Object
Syntax

object.AddStepToJob( JobStep )

Parts

object

Expression that evaluates to an object in the Applies To list

JobStep

Expression that evaluates to a JobStep object

Prototype (C/C++)

HRESULT AddStepToJob(LPSQLDMOJOBSTEP pJobStep);

Remarks

SQL Server Agent automated task administration is configured by adding, removing, and controlling the execution logic of job steps within jobs.

When using SQL-DMO, use the AddStepToJob method, or the Add method of the JobSteps collection, to specify additional steps for an administrative task automated in a SQL Server Agent job.