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.
命名空间: Microsoft.SqlServer.Replication
程序集: Microsoft.SqlServer.Rmo(在 Microsoft.SqlServer.Rmo.dll 中)
语法
声明
Public Function ScriptMergeDynamicSnapshotJob ( _
mergeDynamicSnapshotJob As MergeDynamicSnapshotJob, _
schedule As ReplicationAgentSchedule, _
scriptOption As ScriptOptions _
) As String
用法
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
参数
- mergeDynamicSnapshotJob
类型:Microsoft.SqlServer.Replication.MergeDynamicSnapshotJob
The merge dynamic snapshot job to be scripted.
- schedule
类型:Microsoft.SqlServer.Replication.ReplicationAgentSchedule
The replication agent schedule.
- scriptOption
类型:Microsoft.SqlServer.Replication.ScriptOptions
The scripting options.
返回值
类型:System.String
The Transact-SQL script.
注释
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.