sp_MShelpsnapshot_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_MShelpsnapshot_agent(nvarchar @publisher
, nvarchar @publisher_db
, nvarchar @publication)

MetaData:

   
--   
--  Name:      
--         sp_MShelpsnapshot_agent  
--               
--  Description:   
--         Displays the following information on snapshot agent:  
--             id  
--             name  
--             publisher_security_mode  
--             publisher_login  
--             publisher_password  
--             job_id  
--             job_login  
--             job_password  
--             schedule_name  
--             frequency_type  
--             frequency_interval  
--             frequency_subday_type  
--             frequency_subday_interval  
--             frequency_relative_interval  
--             frequency_recurrence_factor  
--             active_start_date  
--             active_end_date  
--             active_start_time  
--             active_end_time  
--   
--  Security:   
--         SA  
--  Requires Certificate signature for catalog access  
--   
--  Returns:       
--         0 : success  
--         1 : failure            
--   
  
CREATE PROCEDURE sys.sp_MShelpsnapshot_agent  
(  
    @publisher        sysname,  
    @publisher_db    sysname,  
    @publication    sysname  
)  
AS  
BEGIN  
    DECLARE @publisher_id int  
  
    --  Security Check: require sysadmin  
    IF (ISNULL(IS_SRVROLEMEMBER('sysadmin'),0) = 0)  
    BEGIN  
        RAISERROR(21089,16,-1)   
        RETURN 1  
    END  
  
    --  database must be distribution db  
    IF sys.fn_MSrepl_isdistdb(DB_NAME()) <> 1  
    BEGIN  
        RAISERROR (21482, 16, -1, 'sp_MShelpsnapshot_agent', 'distribution')  
        RETURN (1)  
    END  
  
    SELECT @publisher_id = server_id  
        FROM sys.servers  
        WHERE UPPER(name) = UPPER(@publisher)  
  
    SELECT mssa.id,   
            mssa.name,  
            mssa.publisher_security_mode,  
            mssa.publisher_login,  
            N'-- -- -- -- -- ' as [publisher_password],  
            sjb.job_id,  
            sc.credential_identity as [job_login],  
            N'-- -- -- -- -- ' as [job_password],  
            ss.name as [schedule_name],  
            ss.freq_type as [frequency_type],  
            ss.freq_interval as [frequency_interval],  
            ss.freq_subday_type as [frequency_subday_type],  
            ss.freq_subday_interval as [frequency_subday_interval],  
            ss.freq_relative_interval as [frequency_relative_interval],  
            ss.freq_recurrence_factor as [frequency_recurrence_factor],  
            ss.active_start_date,  
            ss.active_end_date,  
            ss.active_start_time,  
            ss.active_end_time  
        FROM MSsnapshot_agents mssa  
                JOIN msdb..sysjobs sjb  
                    ON convert(uniqueidentifier, mssa.job_id) = sjb.job_id  
                LEFT JOIN msdb..sysjobsteps sj  
                    ON mssa.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  
                LEFT JOIN msdb..sysjobschedules sjs  
                    ON sjs.job_id = sjb.job_id  
                LEFT JOIN msdb..sysschedules ss  
                    ON ss.schedule_id = sjs.schedule_id  
        WHERE mssa.publisher_id = @publisher_id  
            AND mssa.publisher_db = @publisher_db  
            AND mssa.publication = @publication  
  
    RETURN 0  
END