JobSteps Collection

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 않도록 하고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The JobSteps collection contains JobStep objects defining the administrative tasks automated by a SQL Server Agent job.

Properties

Count Property

Methods

Add Method	Refresh Method
Item Method	Remove Method (Collections)
ItemByID Method

주의

When using SQL Distributed Management Objects (SQL-DMO) to create and manage a SQL Server Agent job, an administrative task, called a step, is referenced by a single JobStep object. Adding a JobStep object to the JobSteps collection adds the task to the referenced job, allowing automated task execution.

With the JobSteps collection, you can:

• Add a step (administrative task) to a SQL Server Agent job.

• Remove a step from a SQL Server Agent job.

For more information about configuring job tasks by adding a JobStepobject to or removing it from the JobSteps collection, see the Job Object and JobStep Object sections.

When using the Item or Remove method, the JobSteps collection supports member identification using either name or ordinal reference syntax. For example:

Set oJobStep = oJob.JobSteps("DBCC_CHECKDB_Northwind")

Or

Set oJobStep = oJob.JobSteps(3)

[!참고]

Defining SQL Server Agent job steps using the JobSteps collection requires appropriate privilege. The Microsoft® SQL Server™ login used for SQLServer object connection must be a member of the fixed role public in the system database msdb. With public membership, the connection may add steps to, and remove steps from, jobs belonging to the connected login. Members of the db_owner role in msdb, or members of a role with greater privilege, can modify any SQL Server Agent job.