sys.sp_help_agent_default

general

#stored-procedure

Description

Retrieves the ID of the default configuration for the agent type passed as parameter. This stored procedure is executed at Distributor on any database. The ID of the default configuration for the type of agent. parameter and returns the ID of the default configuration for the , with no default, and can be one of the following values:

Syntax

sp_help_agent_default [ @profile_id = ] profile_id
OUTPUT
, [ @agent_type = ] agent_type
[ ; ]