MergePublication.ScriptMergeDynamicSnapshotJob Method

Reference

Definition

Namespace:: Microsoft.SqlServer.Replication

Assembly:: Microsoft.SqlServer.Rmo.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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.

public:
 System::String ^ ScriptMergeDynamicSnapshotJob(Microsoft::SqlServer::Replication::MergeDynamicSnapshotJob ^ mergeDynamicSnapshotJob, Microsoft::SqlServer::Replication::ReplicationAgentSchedule ^ schedule, Microsoft::SqlServer::Replication::ScriptOptions scriptOption);

public string ScriptMergeDynamicSnapshotJob (Microsoft.SqlServer.Replication.MergeDynamicSnapshotJob mergeDynamicSnapshotJob, Microsoft.SqlServer.Replication.ReplicationAgentSchedule schedule, Microsoft.SqlServer.Replication.ScriptOptions scriptOption);

member this.ScriptMergeDynamicSnapshotJob : Microsoft.SqlServer.Replication.MergeDynamicSnapshotJob * Microsoft.SqlServer.Replication.ReplicationAgentSchedule * Microsoft.SqlServer.Replication.ScriptOptions -> string

Public Function ScriptMergeDynamicSnapshotJob (mergeDynamicSnapshotJob As MergeDynamicSnapshotJob, schedule As ReplicationAgentSchedule, scriptOption As ScriptOptions) As String

Parameters

mergeDynamicSnapshotJob: MergeDynamicSnapshotJob

The merge dynamic snapshot job to be scripted.

schedule: ReplicationAgentSchedule

The replication agent schedule.

scriptOption: ScriptOptions

The scripting options.

Returns

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.

Applies to