Metodo Job.RemoveAllJobSchedules (Boolean)

Removes all unused schedules from the job.

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

Sintassi

'Dichiarazione
Public Sub RemoveAllJobSchedules ( _
    keepUnusedSchedules As Boolean _
)
'Utilizzo
Dim instance As Job 
Dim keepUnusedSchedules As Boolean

instance.RemoveAllJobSchedules(keepUnusedSchedules)

public void RemoveAllJobSchedules(
    bool keepUnusedSchedules
)

public:
void RemoveAllJobSchedules(
    bool keepUnusedSchedules
)

member RemoveAllJobSchedules : 
        keepUnusedSchedules:bool -> unit

public function RemoveAllJobSchedules(
    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.

Osservazioni

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.

Esempi

The following code example deletes all non-shared schedules from the "Test Job" job.

C#

Server srv = new Server("(local)");
Job jb = srv.JobServer.Jobs["Test Job"];
jb.RemoveAllJobSchedules(true);

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$jb = $srv.JobServer.Jobs["Test Job"]
$jb.RemoveAllJobSchedules($TRUE)

Vedere anche

Riferimento

Job Classe

Overload RemoveAllJobSchedules

Spazio dei nomi Microsoft.SqlServer.Management.Smo.Agent

Altre risorse

Pianificazione delle attività amministrative automatiche in SQL Server Agent

Automatizzazione delle attività amministrative (SQL Server Agent)

sp_delete_jobschedule (Transact-SQL)