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.