Méthode MergePublication.ScriptMergeDynamicSnapshotJob
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.
Espace de noms : Microsoft.SqlServer.Replication
Assembly : Microsoft.SqlServer.Rmo (en Microsoft.SqlServer.Rmo.dll)
Syntaxe
'Déclaration
Public Function ScriptMergeDynamicSnapshotJob ( _
mergeDynamicSnapshotJob As MergeDynamicSnapshotJob, _
schedule As ReplicationAgentSchedule, _
scriptOption As ScriptOptions _
) As String
'Utilisation
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
Paramètres
- 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.
Valeur de retour
Type : System.String
The Transact-SQL script.
Notes
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.