MSsnapshot_agents (T-SQL)

Contains one row for each Snapshot Agent associated with the local Distributor. This table is stored in the distribution database.

Column name Data type Description
id int ID of the Snapshot Agent.
name nvarchar(100) Name of the Snapshot Agent.
publisher_id smallint ID of the Publisher.
publisher_db sysname Name of the Publisher database.
publication sysname Name of the publication.
local_job bit Indicates whether there is a SQL Server Agent job on the local Distributor.
job_id binary(16) Job identification number.
profile_id int Configuration ID from the MSagent_profiles table.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.