MSagent_parameters (Transact-SQL)
SQL Server 2005
The MSagent_parameters table contains parameters associated with an agent profile. The parameter names are the same as those supported by the agent. This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
|
profile_id |
int |
The profile ID from the MSagent_profiles table. |
|
parameter_name |
sysname |
The name of the parameter. |
|
value |
nvarchar(255) |
The value of the parameter. |
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System ViewsOther Resources
Integration Services TablesBackup and Restore Tables
Log Shipping Tables