MergeDynamicSnapshotJob Object
The MergeDynamicSnapshotJob object represents a dynamic snapshot job that is part of a merge publication.
Methods
| BeginAlter Method | CancelAlter Method |
| DoAlter Method | Remove Method (Objects) |
Properties
| DynamicFilterHostName Property | DynamicSnapshotLocation Property |
| DynamicFilterLogin Property | Name Property |
| DynamicSnapshotJobId Property |
Remarks
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
- Create a new MergeDynamicSnapshotJob object.
- Optionally set the Name property, specifying a name that is unique among all job names at the Distributor.
- Set the DynamicFilterHostName property to the name of a Subscriber.
- Set the DynamicFilterLogin property to the login ID of a Subscriber.
- Set the DynamicSnapshotLocation property to the path where the dynamic snapshot files are generated.
- Add the MergeDynamicSnapshotJob object to the MergeDynamicSnapshotJobs collection of a connected MergePublication object.
Note 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
- Get a MergeDynamicSnapshotJob object from the MergeDynamicSnapshotJobs collection of a connected MergePublication object.
- Use the Remove method to remove the dynamic snapshot job.
Note The MergeDynamicSnapshotJob object is only compatible with instances of SQL Server 2000.