T-SQL to find Job Name of Subscribed Reports | SansSQL

Tuesday, September 2, 2014

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.

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

2 comments:

oracle fusion hcm online Training said...

This is really an awesome article. Thank you for sharing this. It is worth reading for everyone
for more information please visit site:
Oracle Fusion procurement Training
Oracle Fusion Cloud procurement Training

ORACLE FUSION PROCUREMENT said...

hi,
This is a good article.thanks for sharing such a nice article.
oracle fusion SCM online training

Post a Comment