MergePublication.ScriptMergeDynamicSnapshotJob Method

Generates a Transact-SQL script that can be used to re-create the Snapshot Agent job that generates a Subscriber's partitioned data snapshot for publications with a parameterized row filter.

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

Syntax

'Declaration
Public Function ScriptMergeDynamicSnapshotJob ( _
    mergeDynamicSnapshotJob As MergeDynamicSnapshotJob, _
    schedule As ReplicationAgentSchedule, _
    scriptOption As ScriptOptions _
) As String
'Usage
Dim instance As MergePublication 
Dim mergeDynamicSnapshotJob As MergeDynamicSnapshotJob 
Dim schedule As ReplicationAgentSchedule 
Dim scriptOption As ScriptOptions 
Dim returnValue As String 

returnValue = instance.ScriptMergeDynamicSnapshotJob(mergeDynamicSnapshotJob, _
    schedule, scriptOption)

public string ScriptMergeDynamicSnapshotJob(
    MergeDynamicSnapshotJob mergeDynamicSnapshotJob,
    ReplicationAgentSchedule schedule,
    ScriptOptions scriptOption
)

public:
String^ ScriptMergeDynamicSnapshotJob(
    MergeDynamicSnapshotJob^ mergeDynamicSnapshotJob, 
    ReplicationAgentSchedule^ schedule, 
    ScriptOptions scriptOption
)

member ScriptMergeDynamicSnapshotJob : 
        mergeDynamicSnapshotJob:MergeDynamicSnapshotJob * 
        schedule:ReplicationAgentSchedule * 
        scriptOption:ScriptOptions -> string

public function ScriptMergeDynamicSnapshotJob(
    mergeDynamicSnapshotJob : MergeDynamicSnapshotJob, 
    schedule : ReplicationAgentSchedule, 
    scriptOption : ScriptOptions
) : String

Parameters

• mergeDynamicSnapshotJob
  Type: Microsoft.SqlServer.Replication.MergeDynamicSnapshotJob
  The merge dynamic snapshot job to be scripted.

• schedule
  Type: Microsoft.SqlServer.Replication.ReplicationAgentSchedule
  The replication agent schedule.

• scriptOption
  Type: Microsoft.SqlServer.Replication.ScriptOptions
  The scripting options.

Return Value

Type: System.String
The Transact-SQL script.

Remarks

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