• Internally, SQL Server matches the snapshot agents to SQL Jobs. You can access this information from the distribution database:

    select *

    from dbo.MSsnapshot_agents as mssa

    inner join msdb.dbo.sysjobs_view as sjv

    on mssa.job_id = sjv.job_id

    inner join msdb.dbo.sysjobsteps as sjs

    on sjv.job_id = sjs.job_id

    where sjv.category_id = 15

    and sjs.subsystem = N'Snapshot'

    and mssa.dynamic_filter_login is NULL

    and mssa.dynamic_filter_hostname is NULL