sys.sp_add_agent_parameter

Description

Adds a new parameter and its value to an agent profile. This stored procedure is executed at the Distributor on any database. The ID of the profile from the To find out what agent type this field value. The values are as follows:

Syntax

sp_add_agent_parameter [ @profile_id = ] profile_id
, [ @parameter_name = ]
'parameter_name'
, [ @parameter_value = ]
'parameter_value'
[ ; ]