Job.RemoveAllJobSchedules Método (Boolean)
Removes all unused schedules from the job.
Espacio de nombres: Microsoft.SqlServer.Management.Smo.Agent
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
Public Sub RemoveAllJobSchedules ( _
keepUnusedSchedules As Boolean _
)
'Uso
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
)
Parámetros
- 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.
Comentarios
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.
Ejemplos
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)
Vea también
Referencia
Sobrecarga de RemoveAllJobSchedules
Espacio de nombres Microsoft.SqlServer.Management.Smo.Agent
Otros recursos
Programar tareas administrativas automáticas en el Agente SQL Server