Méthode Job.RemoveAllJobSchedules

Removes all shared and unshared schedules from the job.

Espace de noms :  Microsoft.SqlServer.Management.Smo.Agent
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
Public Sub RemoveAllJobSchedules
'Utilisation
Dim instance As Job

instance.RemoveAllJobSchedules()

public void RemoveAllJobSchedules()

public:
void RemoveAllJobSchedules()

member RemoveAllJobSchedules : unit -> unit

public function RemoveAllJobSchedules()

Notes

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.

Exemples

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()

Voir aussi

Référence

Job Classe

Surcharge RemoveAllJobSchedules

Espace de noms Microsoft.SqlServer.Management.Smo.Agent

Autres ressources

Planification des tâches administratives automatiques dans l'Agent SQL Server

Tâches d'administration automatisée (Agent SQL Server)

sp_delete_jobschedule (Transact-SQL)