Skip to content

Latest commit

 

History

History
35 lines (30 loc) · 1.41 KB

msqreader-agents-transact-sql.md

File metadata and controls

35 lines (30 loc) · 1.41 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
MSqreader_agents (Transact-SQL)
MSqreader_agents (Transact-SQL)
VanMSFT
vanto
03/14/2017
sql
replication
reference
MSqreader_agents_TSQL
MSqreader_agents
MSqreader_agents system table
TSQL

MSqreader_agents (Transact-SQL)

[!INCLUDE SQL Server]

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 [!INCLUDEssNoVersion] Agent job step in which the agent is started.

See Also

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