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:

SELECT  
        ScheduleID ,
        Path ,
        c.Name ,
        s.Description,
        j.job_id AS JOB_ID,
        j.name 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) = j.name
 
USE msdb ;
GO
EXEC dbo.sp_start_job 
    @job_name = 'XXXXXXXXXXXXXXXXXXXXXXX'
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License