sp_help_agent_parameter

Transact-SQL Reference

Transact-SQL Reference

sp_help_agent_parameter

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