Método Job.RemoveAllJobSteps
Removes all the job steps associated with the job.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
Public Sub RemoveAllJobSteps
'Uso
Dim instance As Job
instance.RemoveAllJobSteps()
public void RemoveAllJobSteps()
public:
void RemoveAllJobSteps()
member RemoveAllJobSteps : unit -> unit
public function RemoveAllJobSteps()
Comentários
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.
Exemplos
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()
Consulte também
Referência
Namespace Microsoft.SqlServer.Management.Smo.Agent
Outros recursos
Agendando tarefas administrativas automáticas no SQL Server Agent