MSdynamicsnapshotjobs (Transact-SQL)
Applies to:
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. |
See Also
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir