sys.sp_add_agent_profile

Description

Creates a new profile for a replication agent. This stored procedure is executed at the The ID associated with the newly inserted profile. parameter. If specified, the value is set to the new profile ID. The type of replication agent.

Syntax

sp_add_agent_profile [ [ @profile_id = ] profile_id
OUTPUT
]
, [ @profile_name = ]
'profile_name'
, [ @agent_type = ] agent_type
[ , [ @profile_type = ] profile_type ]
[ , [ @description = ]
N
'description'
]
[ , [ @default = ] default ]

Permissions

When is executed, a row is added for the new custom profile in the MSagent_profiles table and the associated default parameters for this profile are added to the MSagent_parameters table. Only members of the fixed server role can execute. Work with Replication Agent Profiles Replication Agent Profiles sp_add_agent_parameter (Transact-SQL) sp_change_agent_parameter (Transact-SQL) sp_change_agent_profile (Transact-SQL) sp_drop_agent_parameter (Transact-SQL) sp_drop_agent_profile (Transact-SQL) sp_help_agent_parameter (Transact-SQL) sp_help_agent_profile (Transact-SQL)