Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Removes the specified shared schedule from the job.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Sub RemoveSharedSchedule ( _
scheduleId As Integer _
)
'Usage
Dim instance As Job
Dim scheduleId As Integer
instance.RemoveSharedSchedule(scheduleId)
public void RemoveSharedSchedule(
int scheduleId
)
public:
void RemoveSharedSchedule(
int scheduleId
)
member RemoveSharedSchedule :
scheduleId:int -> unit
public function RemoveSharedSchedule(
scheduleId : int
)
Parameters
- scheduleId
Type: System.Int32
An Int32 value that specifies the ID value that uniquely identifies the shared schedule.
Examples
The following code example creates a job schedule, shares it between two jobs, then removes it from one of them.
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.RemoveSharedSchedule(jbsch.ID);
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.RemoveSharedSchedule($jbsch.ID)
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace
Other Resources
Scheduling Automatic Administrative Tasks in SQL Server Agent