Condividi tramite


Metodo RemoveAllJobSteps

Removes all the job steps associated with the job.

Spazio dei nomi  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
Public Sub RemoveAllJobSteps
'Utilizzo
Dim instance As Job

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

Osservazioni

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.

Esempi

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()