sp_help_agent_profile (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_help_agent_profile(int @agent_type
, int @profile_id)

MetaData:

   
  
--   
--  Name: sp_help_agent_profile  
--   
--  Description:   
--  View the row(s) of the MSagent_profiles table  
--   
--  Parameter: Refer to the comments in the create procedure statement  
--   
--  Returns: 1 or 0   0 = success  
--   
--  Resultset:  
--  profile_id int  
--   
--  Security: Public procedure - sa or replmonitor   
--  Requires Certificate signature for catalog access  
--   
create procedure sys.sp_help_agent_profile(  
    @agent_type     int = 0,  
    @profile_id int = -1  
)  
as  
    set nocount on  
  
    declare @proc nvarchar(255)  
  
    declare @snapshot_type      int  
    declare @logreader_type     int  
    declare @distribution_type  int  
    declare @merge_type     int  
    declare @qreader_type       int  
  
    select @snapshot_type = 1  
    select @logreader_type = 2  
    select @distribution_type = 3  
    select @merge_type = 4  
    select @qreader_type = 9  
  
   --  Security Check: Must be sysadmin or the replmonitor  
   if isnull(is_member(N'replmonitor'),0) = 0 and isnull(is_srvrolemember(N'sysadmin'),0) = 0  
   begin  
     RAISERROR(14260,16,-1)   
     return 1  
   end  
  
    if @agent_type is null   
    BEGIN  
        RAISERROR (14043, 16, -1, '@agent_type', 'sp_help_agent_profile')  
        RETURN (1)  
    END  
  
    if @profile_id is null  
    BEGIN  
        RAISERROR (14043, 16, -1, '@profile_id', 'sp_help_agent_profile')  
        RETURN (1)  
    END  
  
    if @agent_type not in (0, @snapshot_type, @logreader_type, @distribution_type, @merge_type, @qreader_type)  
    BEGIN  
        RAISERROR(20058, 16, -1)  
        return (1)  
    END  
  
    select profile_id, profile_name, agent_type, type, description, def_profile  
        from msdb.dbo.MSagent_profiles where  
             (profile_id = @profile_id or @profile_id = -1) and  
             (agent_type = @agent_type or @agent_type = 0)  
        order by profile_id, profile_name