MSdynamicsnapshotjobs

Transact-SQL Reference

Transact-SQL Reference

MSdynamicsnapshotjobs

The MSdynamicsnapshotjobs table tracks the dynamic filter information applied to a dynamic snapshot. This table is stored in the publication and subscription databases.

Column name Data type Description
id int ID for the dynamic snapshot job.
name sysname Name of the dynamic snapshot job.
pubid uniqueidentifier Unique identification number for this publication.
job_id uniqueidentifier ID of the SQL Server Agent job at the Distributor.
dynamic_filter_login sysname Value used for evaluating the SUSER_SNAME() function in dynamic filters defined for the publication.
dynamic_filter_hostname sysname Value used for evaluating the HOSTNAME() function in dynamic filters defined for the publication.
dynamic_snapshot_location nvarchar(255) Path to the folder where the snapshot files will be read from if a dynamic snapshot is to be used.