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.