Job.Drop 메서드 (Boolean)

Removes an existing job.

네임스페이스:  Microsoft.SqlServer.Management.Smo.Agent
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
Public Sub Drop ( _
    keepUnusedSchedules As Boolean _
)
‘사용 방법
Dim instance As Job 
Dim keepUnusedSchedules As Boolean

instance.Drop(keepUnusedSchedules)
public void Drop(
    bool keepUnusedSchedules
)
public:
void Drop(
    bool keepUnusedSchedules
)
member Drop : 
        keepUnusedSchedules:bool -> unit
public function Drop(
    keepUnusedSchedules : boolean
)

매개 변수

  • keepUnusedSchedules
    유형: System.Boolean
    A Boolean value that specifies whether to keep the unused schedules from the removed job.If True, the shared schedules are kept.If False, the shared schedules are not kept.

The following code example creates a job schedule and shares it between two jobs.

C#

Server srv = new Server("(local)");
Job jb = new Job(srv.JobServer, "Test Job");
Job jb2 = new Job(srv.JobServer, "Second Test Job");
jb.Create();
jb2.Create();
JobSchedule jbsch = new JobSchedule(jb, "Test Job Schedule");
jbsch.Create();
jb2.AddSharedSchedule(jbsch.ID);
jb.Drop(true);

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$jb = new-object Microsoft.SqlServer.Management.Smo.Agent.Job($srv.JobServer, "Test Job")
$jb2 = new-object Microsoft.SqlServer.Management.Smo.Agent.Job($srv.JobServer, "Second Test Job")
$jb.Create()
$jb2.Create()
$jbsch = new-object Microsoft.SqlServer.Management.Smo.Agent.JobSchedule($jb, "Test Job Schedule")
$jbsch.Create()
$jb2.AddSharedSchedule($jbsch.ID)
$jb.Drop($TRUE)

참고 항목

참조

Job 클래스

Drop 오버로드

Microsoft.SqlServer.Management.Smo.Agent 네임스페이스

관련 자료

관리 태스크 자동화(SQL Server 에이전트)

sp_delete_job(Transact-SQL)

SQL Server 에이전트에서 자동 관리 태스크 예약