مشاركة عبر


MergePublication.GetMergeDynamicSnapshotJobScheduleWithJobId Method

Returns 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 Function GetMergeDynamicSnapshotJobScheduleWithJobId ( _
    dynamicSnapshotJobId As String _
) As ReplicationAgentSchedule
'Usage
Dim instance As MergePublication 
Dim dynamicSnapshotJobId As String 
Dim returnValue As ReplicationAgentSchedule 

returnValue = instance.GetMergeDynamicSnapshotJobScheduleWithJobId(dynamicSnapshotJobId)
public ReplicationAgentSchedule GetMergeDynamicSnapshotJobScheduleWithJobId(
    string dynamicSnapshotJobId
)
public:
ReplicationAgentSchedule^ GetMergeDynamicSnapshotJobScheduleWithJobId(
    String^ dynamicSnapshotJobId
)
member GetMergeDynamicSnapshotJobScheduleWithJobId : 
        dynamicSnapshotJobId:string -> ReplicationAgentSchedule
public function GetMergeDynamicSnapshotJobScheduleWithJobId(
    dynamicSnapshotJobId : 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 GetMergeDynamicSnapshotJobScheduleWithJobId is equivalent to executing sp_helpdynamicsnapshot_job.

The GetMergeDynamicSnapshotJobScheduleWithJobId 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