MSqreader_agents (Transact-SQL)


Applies To: 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 nameData typeDescription
idintThe ID of the Queue Reader Agent.
namenvarchar(100)The name of the Queue Reader Agent.
job_idbinary(16)The unique job ID number from sysjobs table.
profile_idintThe profile ID from the MSagent_profiles table.
job_step_uiduniqueidentifierThe unique ID of the SQL Server Agent job step in which the agent is started.

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

Community Additions