Metodo Job.Drop (Boolean)

Articolo
04/26/2013

Removes an existing job.

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

Sintassi

'Dichiarazione
Public Sub Drop ( _
    keepUnusedSchedules As Boolean _
)
'Utilizzo
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
)

Parametri

keepUnusedSchedules
Tipo: 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.

Esempi

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

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)