MSqreader_agents (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Column name Data type Description
id int The ID of the Queue Reader Agent.
name nvarchar(100) The name of the Queue Reader Agent.
job_id binary(16) The unique job ID number from sysjobs table.
profile_id int The profile ID from the MSagent_profiles table.
job_step_uid uniqueidentifier The unique ID of the SQL Server Agent job step in which the agent is started.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)