MSdynamicsnapshotjobs (Transact-SQL)
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. |