MergeDynamicSnapshotJobs Collection

SQL-DMO

Remarks

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.

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.

Note  The UserDefinedFunctions collection is not compatible with Microsoft® SQL Server™ version 7.0 or earlier.