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