Share via

  • 项目

MergeDynamicSnapshotJobs Collection

后续版本的 Microsoft SQL Server 将删除该功能。 请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。

The MergeDynamicSnapshotJobs collection is a group of MergeDynamicSnapshotJob objects.

显示当前对象的 SQL-DMO 对象模型

注释

With the MergeDynamicSnapshotJobs collection, you can:

  • Add a dynamic snapshot job to a merge publication.

To add a dynamic snapshot job to a merge publication

  1. Create a new MergeDynamicSnapshotJob object.

  2. Optionally set the Name property, specifying a name that is unique among all job names at the Distributor.

  3. Set the DynamicFilterHostName property to the name of a Subscriber.

  4. Set the DynamicFilterLogin property to the login ID of a Subscriber.

  5. Set the DynamicSnapshotLocation property to the path where the dynamic snapshot files are generated.

  6. Add the MergeDynamicSnapshotJob object to the MergeDynamicSnapshotJobs collection of a connected MergePublication object.

    注意注意

    If the Name property is not set, a default name is generated in the form of dyn_ + (job name of the regular snapshot job of the publication) + string GUID.

Note   The MergeDynamicSnapshotJobs collection is not compatible with Microsoft SQL Server version 7.0 or earlier.