How To Identify A Scheduled Sql Server Reporting Services Re

An easy way to identify a scheduled SQL Server Reporting Services report using T-SQL script:

        ScheduleID ,
        Path ,
        c.Name ,
        j.job_id AS JOB_ID, AS JOB_NAME
FROM    ReportServer.dbo.Catalog c
        JOIN ReportServer.dbo.Subscriptions s ON c.ItemID = s.Report_OID
        JOIN ReportServer.dbo.ReportSchedule rs ON rs.SubscriptionID = s.SubscriptionID
JOIN msdb.dbo.sysjobs j ON CONVERT(sysname,rs.ScheduleID) =
USE msdb ;
EXEC dbo.sp_start_job 
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License