MSagent_parameters (Transact-SQL)

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.

See Also

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance