msqreader-agents-transact-sql.md

title	MSqreader_agents (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	MSqreader_agents_TSQL MSqreader_agents
dev_langs	TSQL
helpviewer_keywords	MSqreader_agents system table
ms.assetid	dfa1f45e-c531-4385-a097-0a9edd1d7eab
author	stevestein
ms.author	sstein

MSqreader_agents (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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)