MSagentparameterlist (Transact-SQL)

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

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 name Data type Description
agent_type tinyint The type of agent:

1 = Snapshot Agent.

2 = Log Reader Agent.

3 = Distribution Agent.

4 = Merge Agent.

9 = Queue Reader Agent.
parameter_name sysname The name of a valid agent parameter.
default_value nvarchar(4000) The default value for the agent parameter, where NULL indicates that no such value exists.
min_value int Sets a lower bound for the agent parameter, where NULL indicates no lower bound.
max_value int Sets an upper bound for the agent parameter, where NULL indicates no upper bound.

See Also

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