Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2000
System Tables
 MSagent_parameters
Transact-SQL Reference (SQL Server 2000)
MSagent_parameters

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 Profile ID from the MSagent_profiles table.
parameter_name sysname Name of the parameter.
value nvarchar(255) Value of the parameter.

© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker