MergePublication.GetMergeDynamicSnapshotJobScheduleWithJobName Method
Returns 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 Function GetMergeDynamicSnapshotJobScheduleWithJobName ( _
dynamicSnapshotJobName As String _
) As ReplicationAgentSchedule
'Usage
Dim instance As MergePublication
Dim dynamicSnapshotJobName As String
Dim returnValue As ReplicationAgentSchedule
returnValue = instance.GetMergeDynamicSnapshotJobScheduleWithJobName(dynamicSnapshotJobName)
public ReplicationAgentSchedule GetMergeDynamicSnapshotJobScheduleWithJobName(
string dynamicSnapshotJobName
)
public:
ReplicationAgentSchedule^ GetMergeDynamicSnapshotJobScheduleWithJobName(
String^ dynamicSnapshotJobName
)
member GetMergeDynamicSnapshotJobScheduleWithJobName :
dynamicSnapshotJobName:string -> ReplicationAgentSchedule
public function GetMergeDynamicSnapshotJobScheduleWithJobName(
dynamicSnapshotJobName : String
) : ReplicationAgentSchedule
Parameters
- dynamicSnapshotJobName
Type: System.String
The job name.
Return Value
Type: Microsoft.SqlServer.Replication.ReplicationAgentSchedule
The schedule for the Snapshot Agent job that generates the filtered data partition for a Subscriber.
Remarks
Calling GetMergeDynamicSnapshotJobScheduleWithJobName is equivalent to executing sp_helpdynamicsnapshot_job.
The GetMergeDynamicSnapshotJobScheduleWithJobName 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)