sys.sp_drop_agent_parameter

Description

Drops one or all parameters from a profile in the table. This stored procedure is executed at the Distributor where the agent is running, on any database. The ID of the profile for which a parameter is to be dropped. , with no default.

Syntax

sp_drop_agent_parameter

Permissions

Only members of the fixed server role can execute. sp_add_agent_parameter (Transact-SQL) sp_help_agent_parameter (Transact-SQL) System stored procedures (Transact-SQL)

Remarks

Drops one or all parameters from a profile in the

table. This stored

procedure is executed at the Distributor where the agent is running, on any database.

The ID of the profile for which a parameter is to be dropped.

@profile_id

, with no default.

The name of the parameter to be dropped.

@parameter_name

, with a default of

, all parameters for the specified profile are dropped.

(success) or

is used in all types of replication.