Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_help_agent_parameter

SQL Server 2000

Returns all the parameters of a profile from the MSagent_parameters system table. This stored procedure is executed at the Distributor where the agent is running, on any database.

Syntax

sp_help_agent_parameter [ [ @profile_id = ] profile_id ]

Arguments

[@profile_id = ] profile_id

Is the ID of the profile from  the MSagent_profiles table. profile_id is int, with a default of -1, which returns all parameters.

Result Sets
Column name Data type Description
profile_id int ID of the agent profile.
parameter_name sysname Name of the parameter.
value nvarchar(255) Value of the parameter.

Remarks

sp_help_agent_parameter is used in all types of replication.

Permissions

Execute permissions default to the public role.

See Also

sp_add_agent_parameter

sp_drop_agent_parameter

System Stored Procedures

Show:
© 2014 Microsoft. All rights reserved.