MSagentparameterlist (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

MSagentparameterlist (Transact-SQL)

 

Applies To: SQL Server

The MSagentparameterlist table contains replication agent parameter information and is used to specify the parameters that can be set for a given agent type. This table is stored in the msdb database.

Column nameData typeDescription
agent_typetinyintThe type of agent:

 1 = Snapshot Agent.

 2 = Log Reader Agent.

 3 = Distribution Agent.

 4 = Merge Agent.

 9 = Queue Reader Agent.
parameter_namesysnameThe name of a valid agent parameter.
default_valuenvarchar(4000)The default value for the agent parameter, where NULL indicates that no such value exists.
min_valueintSets a lower bound for the agent parameter, where NULL indicates no lower bound.
max_valueintSets an upper bound for the agent parameter, where NULL indicates no upper bound.

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

Community Additions

ADD
Show:
© 2016 Microsoft