Share via


MergePublication.RemoveMergeDynamicSnapshotJob Method

Removes the specified dynamic snapshot job from the merge publication.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public Sub RemoveMergeDynamicSnapshotJob ( _
    dynamicSnapshotJobName As String _
)
'Usage
Dim instance As MergePublication 
Dim dynamicSnapshotJobName As String

instance.RemoveMergeDynamicSnapshotJob(dynamicSnapshotJobName)
public void RemoveMergeDynamicSnapshotJob(
    string dynamicSnapshotJobName
)
public:
void RemoveMergeDynamicSnapshotJob(
    String^ dynamicSnapshotJobName
)
member RemoveMergeDynamicSnapshotJob : 
        dynamicSnapshotJobName:string -> unit
public function RemoveMergeDynamicSnapshotJob(
    dynamicSnapshotJobName : String
)

Parameters

  • dynamicSnapshotJobName
    Type: System.String
    The name of the dynamic snapshot job.

Remarks

Calling RemoveMergeDynamicSnapshotJob is equivalent to executing sp_dropdynamicsnapshot_job.

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