MergePublication.ScriptMergeDynamicSnapshotJob Method
Definition
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 -> stringPublic Function ScriptMergeDynamicSnapshotJob (mergeDynamicSnapshotJob As MergeDynamicSnapshotJob, schedule As ReplicationAgentSchedule, scriptOption As ScriptOptions) As StringParameters
- mergeDynamicSnapshotJob
- MergeDynamicSnapshotJob
The merge dynamic snapshot job to be scripted.
- schedule
- ReplicationAgentSchedule
The replication agent schedule.
- scriptOption
- ScriptOptions
The scripting options.
Returns
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.