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. |