MergePublication.ChangeMergeDynamicSnapshotJobScheduleWithJobName Method
Modifies the schedule for the Snapshot Agent job that generates the filtered data partition for a Subscriber, based on the job name.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
Syntax
'Declaration
Public Sub ChangeMergeDynamicSnapshotJobScheduleWithJobName ( _
dynamicSnapshotJobName As String, _
schedule As ReplicationAgentSchedule _
)
'Usage
Dim instance As MergePublication
Dim dynamicSnapshotJobName As String
Dim schedule As ReplicationAgentSchedule
instance.ChangeMergeDynamicSnapshotJobScheduleWithJobName(dynamicSnapshotJobName, _
schedule)
public void ChangeMergeDynamicSnapshotJobScheduleWithJobName(
string dynamicSnapshotJobName,
ReplicationAgentSchedule schedule
)
public:
void ChangeMergeDynamicSnapshotJobScheduleWithJobName(
String^ dynamicSnapshotJobName,
ReplicationAgentSchedule^ schedule
)
member ChangeMergeDynamicSnapshotJobScheduleWithJobName :
dynamicSnapshotJobName:string *
schedule:ReplicationAgentSchedule -> unit
public function ChangeMergeDynamicSnapshotJobScheduleWithJobName(
dynamicSnapshotJobName : String,
schedule : ReplicationAgentSchedule
)
Parameters
- dynamicSnapshotJobName
Type: System.String
The job name value.
- schedule
Type: Microsoft.SqlServer.Replication.ReplicationAgentSchedule
The new job schedule.
Remarks
Calling ChangeMergeDynamicSnapshotJobScheduleWithJobName is equivalent to executing sp_changedynamicsnapshot_job.
The ChangeMergeDynamicSnapshotJobScheduleWithJobName 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)