DMVs Waits Cookbook Scripts XEvents SPs Catalog Functions Errors T-SQL Arch Ops

sys.sp_drop_agent_profile

general
#stored-procedure

Description

table. This stored procedure is executed at the The ID of the profile to be dropped. is used in all types of replication.

Syntax

sp_drop_agent_profile

Permissions

06/23/2025 This stored procedure is executed at the Distributor on any database. syntaxsql The ID of the profile to be dropped. @profile_id is , with no default. (success) or (failure). is used in all types of replication. The parameters of the given profile are also dropped from the table. Only members of the fixed server role can execute.