MSlogreader_agents

Transact-SQL Reference

Transact-SQL Reference

MSlogreader_agents

The MSlogreader_agents table contains one row for each Log Reader Agent running at the local Distributor. This table is stored in the distribution database.

Column name Data type Description
id int ID of the Log Reader Agent.
name nvarchar(100) Name of the Log Reader 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.