New answers tagged

0

This simple query on MSDB should get you started: SELECT s2.subsystem AS [TypeOfJobStep]-- when subsystem = 'SSIS' then 'SSIS job step' , s2.command AS [JobStepCommand] , s.name AS [JobName] FROM dbo.sysjobs AS s JOIN dbo.sysjobsteps AS s2 ON s2.job_id = s.job_id You can identify SSRS subscriptions because their name will be alternating ...



Top 50 recent answers are included