MergePublication.ChangeMergeDynamicSnapshotJobScheduleWithJobId Method
Modifies the schedule for the Snapshot Agent job that generates the filtered data partition for a Subscriber, based on the job ID.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
Syntax
'Declaration
Public Sub ChangeMergeDynamicSnapshotJobScheduleWithJobId ( _
dynamicSnapshotJobId As String, _
schedule As ReplicationAgentSchedule _
)
'Usage
Dim instance As MergePublication
Dim dynamicSnapshotJobId As String
Dim schedule As ReplicationAgentSchedule
instance.ChangeMergeDynamicSnapshotJobScheduleWithJobId(dynamicSnapshotJobId, _
schedule)
public void ChangeMergeDynamicSnapshotJobScheduleWithJobId(
string dynamicSnapshotJobId,
ReplicationAgentSchedule schedule
)
public:
void ChangeMergeDynamicSnapshotJobScheduleWithJobId(
String^ dynamicSnapshotJobId,
ReplicationAgentSchedule^ schedule
)
member ChangeMergeDynamicSnapshotJobScheduleWithJobId :
dynamicSnapshotJobId:string *
schedule:ReplicationAgentSchedule -> unit
public function ChangeMergeDynamicSnapshotJobScheduleWithJobId(
dynamicSnapshotJobId : String,
schedule : ReplicationAgentSchedule
)
Parameters
- dynamicSnapshotJobId
Type: System.String
The job ID value.
- schedule
Type: Microsoft.SqlServer.Replication.ReplicationAgentSchedule
The new job schedule.
Remarks
Calling ChangeMergeDynamicSnapshotJobScheduleWithJobId is equivalent to executing sp_changedynamicsnapshot_job.
The ChangeMergeDynamicSnapshotJobScheduleWithJobId method can only be called by members of the sysadmin fixed server role at the Publisher or by members of the db_owner fixed database role on the publication database.
See Also
Reference
Microsoft.SqlServer.Replication Namespace
Other Resources
NIB Create a Snapshot for a Merge Publication with Parameterized Filters (RMO Programming)
NIB How to: Manage Partitions for a Merge Publication with Parameterized Filters (RMO Programming)