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()
참고 항목
참조
Microsoft.SqlServer.Management.Smo.Agent 네임스페이스