共用方式為


MergeDynamicSnapshotJob Object

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The MergeDynamicSnapshotJob object represents a dynamic snapshot job that is part of a merge publication.

顯示目前物件的 SQL-DMO 物件模型

Methods

BeginAlter Method

CancelAlter Method

DoAlter Method

Remove Method (Objects)

Properties

DynamicFilterHostName Property

DynamicSnapshotLocation Property

DynamicFilterLogin Property

Name Property

DynamicSnapshotJobId Property

 

備註

With the MergeDynamicSnapshotJob object, you can:

  • Add a dynamic snapshot job to a merge publication.
  • Set the properties of a dynamic snapshot job prior to its creation.
  • Remove a dynamic snapshot job from 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.

    ms131956.note(zh-tw,SQL.90).gif附註:
    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.

To remove a dynamic snapshot job from a merge publication

  1. Get a MergeDynamicSnapshotJob object from the MergeDynamicSnapshotJobs collection of a connected MergePublication object.

  2. Use the Remove method to remove the dynamic snapshot job.

    ms131956.note(zh-tw,SQL.90).gif附註:
    The MergeDynamicSnapshotJob object is only compatible with instances of Microsoft SQL Server 2000 and later.