sp_helpqreader_agent (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_helpqreader_agent(bit @frompublisher)

MetaData:

 --   
--  Name:      
--         sp_helpqreader_agent  
--               
--  Description:   
--         Displays the following information on qreader agent:  
--             QA ID  
--             NAME  
--             Job ID  
--             Job Login  
--             Job Password (dummy value of 10 *'s)  
--       
--  Security:   
--         DBO of distributiondb  
--  Requires Certificate signature for catalog access  
--   
--  Returns:       
--         0 : success  
--         1 : failure            
--   
CREATE PROCEDURE sys.sp_helpqreader_agent  
(  
    @frompublisher bit = 0  
)  
AS  
BEGIN  
    DECLARE @retcode int  
      
    IF @frompublisher = 0  
    BEGIN  
        --  Security Check: require sysadmin/dbo of dist   
        IF IS_SRVROLEMEMBER('sysadmin') != 1  
        BEGIN  
            RAISERROR(21089,16,-1)   
            RETURN 1  
        END  
  
        --  database must be distribution db or we exit with no resultset  
        IF sys.fn_MSrepl_isdistdb(DB_NAME()) <> 1  
        BEGIN  
            RETURN 0  
        END  
    END  
    ELSE  
    BEGIN  
        --  Security Check: require sysadmin/dbo of publisher   
        IF IS_SRVROLEMEMBER('sysadmin') != 1  
            AND IS_MEMBER ('db_owner') != 1  
        BEGIN  
            RAISERROR(21089,16,-1)   
            RETURN 1  
        END  
  
        --  only verify this for the DBO case, sysadmin gets a pass  
        IF IS_SRVROLEMEMBER('sysadmin') != 1  
        BEGIN  
            --  must be tran published or we exit with no resultset  
            IF sys.fn_MSrepl_istranpublished(DB_NAME(),0) <> 1  
            BEGIN  
                RETURN 0  
            END  
        END  
    END  
  
    --   
    --  if executed from publisher  
    --   
    IF @frompublisher = 1  
    BEGIN  
        DECLARE @loc_publisher sysname  
                ,@loc_distribdb sysname  
                ,@rpcsrvname sysname  
                ,@rpc nvarchar(1000)  
        --   
        --  get the distributor rpc info  
        --   
        SELECT @loc_publisher = CONVERT(sysname, SERVERPROPERTY('ServerName'))  
        EXEC @retcode = sys.sp_MSrepl_getdistributorinfo @publisher = @loc_publisher,  
                                                            @rpcsrvname = @rpcsrvname OUTPUT,  
                                                            @distribdb = @loc_distribdb OUTPUT  
  
        IF @@error <> 0 OR @retcode <> 0 or (@rpcsrvname IS NULL) or (@loc_distribdb IS NULL)  
        BEGIN  
            RAISERROR(20036, 16, -1)  
            RETURN 1  
        END  
        --   
        --  execute the RPC  
        --   
        select @rpc = quotename(@rpcsrvname) + N'.' + quotename(@loc_distribdb) + N'.dbo.sp_helpqreader_agent'  
        exec @retcode = @rpc @frompublisher = 0  
        IF @@error != 0  
            select @retcode = 1  
  
        RETURN @retcode  
    END      
      
    SELECT msqa.id,   
            msqa.name,  
            sjb.job_id,  
            sc.credential_identity as [job_login],  
            N'-- -- -- -- -- ' as [job_password]  
        FROM MSqreader_agents msqa  
            JOIN msdb..sysjobs sjb  
                ON convert(uniqueidentifier, msqa.job_id) = sjb.job_id  
            LEFT JOIN msdb..sysjobsteps sj  
                ON msqa.job_step_uid = sj.step_uid  
            LEFT JOIN msdb..sysproxies sp  
                ON sj.proxy_id = sp.proxy_id  
            LEFT JOIN sys.credentials sc  
                ON sp.credential_id = sc.credential_id  
  
    RETURN 0  
END