| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSdynamicsnapshotjobs (Transact-SQL) |
MSdynamicsnapshotjobs (Transact-SQL) |
VanMSFT |
vanto |
03/06/2017 |
sql |
replication |
reference |
|
|
|
[!INCLUDE SQL Server]
The MSdynamicsnapshotjobs table tracks the parameterized row filter information applied to generate a filtered data snapshot. This table is stored in the publication and subscription databases.
| Column name | Data type | Description |
|---|---|---|
| id | int | The ID for the filtered data snapshot job. |
| name | sysname | The name of the filtered data snapshot job. |
| pubid | uniqueidentifier | The unique identification number for this publication. |
| job_id | uniqueidentifier | The ID of the SQL Server Agent job at the Distributor. |
| agent_id | int | The ID of the SQL Server Agent. |
| dynamic_filter_login | sysname | The value used for evaluating the SUSER_SNAME function in parameterized row filters defined for the publication. |
| dynamic_filter_hostname | sysname | The value used for evaluating the HOST_NAME function in parameterized row filters defined for the publication. |
| dynamic_snapshot_location | nvarchar(255) | The path to the folder where the snapshot files will be read from if a filtered data snapshot is used. |
| partition_id | int | The ID of the data partition to which the job belongs. |