Job.RemoveAllJobSchedules 메서드
Removes all shared and unshared schedules from the job.
네임스페이스: Microsoft.SqlServer.Management.Smo.Agent
어셈블리: Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)
구문
‘선언
Public Sub RemoveAllJobSchedules
‘사용 방법
Dim instance As Job
instance.RemoveAllJobSchedules()
public void RemoveAllJobSchedules()
public:
void RemoveAllJobSchedules()
member RemoveAllJobSchedules : unit -> unit
public function RemoveAllJobSchedules()
주의
On successful execution, the JobSchedules collection property of the Job object is emptied. To reschedule the referenced job, create JobSchedule objects and add them to the JobSchedulescollection property of the Job object.
예
The following code example deletes all schedules from the "Test Job" job.
C#
Server srv = new Server("(local)");
Job jb = srv.JobServer.Jobs["Test Job"];
jb.RemoveAllJobSchedules();
PowerShell
$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$jb = $srv.JobServer.Jobs["Test Job"]
$jb.RemoveAllJobSchedules()
참고 항목
참조
Microsoft.SqlServer.Management.Smo.Agent 네임스페이스