共用方式為


Job.RemoveAllJobSteps 方法

Removes all the job steps associated with the job.

命名空間:  Microsoft.SqlServer.Management.Smo.Agent
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Sub RemoveAllJobSteps
'用途
Dim instance As Job

instance.RemoveAllJobSteps()
public void RemoveAllJobSteps()
public:
void RemoveAllJobSteps()
member RemoveAllJobSteps : unit -> unit
public function RemoveAllJobSteps()

備註

Successful execution of the RemoveAllJobSteps method disables the referenced job, and empties the JobSteps collection property of the Job object. To re-enable the referenced job, create JobStep objects and add them to the JobSteps collection property of the Job object.

範例

The following code example disables the "Test Job" job and deletes all defined steps from it.

C#

Server srv = new Server("(local)");
Job jb = srv.JobServer.Jobs["Test Job"];
jb.RemoveAlljobSteps();

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$jb = $srv.JobServer.Jobs["Test Job"]
$jb.RemoveAllJobSteps()

請參閱

參考

Job 類別

Microsoft.SqlServer.Management.Smo.Agent 命名空間

其他資源

使用 SQL Server Agent 排程自動管理工作

自動化管理工作 (SQL Server Agent)

sp_delete_jobstep (Transact-SQL)