T-SQL to find Job Name of Subscribed Reports

Here is an handy T-SQL script which gives information about your subscribed reports in SSRS.

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

USE ReportServer GO SELECT    SJ.name AS JobName   ,Cat.Name AS ReportName   ,Sub.Description AS SubscriptionDescription   ,Cat.Path AS ReportPath   ,Sub.DeliveryExtension AS SubscriptionDeliveryType   ,Sub.LastStatus   ,Sub.EventType   ,SJ.date_created AS SubscriptionCreatedDate   ,SJ.date_modified AS SubscriptionModifiedDate FROM msdb.dbo.sysjobs SJ INNER JOIN ReportSchedule RS ON SJ.name=CAST(RS.ScheduleID AS VARCHAR(max)) INNER JOIN Subscriptions Sub ON Sub.SubscriptionID=RS.SubscriptionID INNER JOIN Catalog Cat ON Cat.ItemID=Sub.Report_OID