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

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

MergePublication Class

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)

Snapshots for Merge Publications with Parameterized Filters