| title | MSagentparameterlist (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/04/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 4ea571a0-078d-4e13-95ee-f3d4bbd4dfb2 | ||
| caps.latest.revision | 13 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)