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 string ScriptMergeDynamicSnapshotJob(
	MergeDynamicSnapshotJob mergeDynamicSnapshotJob,
	ReplicationAgentSchedule schedule,
	ScriptOptions scriptOption

매개 변수

유형: Microsoft.SqlServer.Replication.MergeDynamicSnapshotJob
The merge dynamic snapshot job to be scripted.
유형: Microsoft.SqlServer.Replication.ReplicationAgentSchedule
The replication agent schedule.
유형: 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.

커뮤니티 추가 항목