SSRS schedule details

SSRS Subscription

          The Report server database will store the SSRS schedule information. This database has the complete information about the report scheduled and its related information like the job through which the report got invoked. The status of the Job and when it got executed. This information is helpful to track the SSRS Report subscription information. 
USE ReportServer
RC.Name AS ReportName
, RS.LastStatus
, RS.LastRunTime
, RS.[Description]
ReportServer..[Catalog] RC
JOIN ReportServer..Subscriptions RS ON RC.ItemID = RS.Report_OID
JOIN ReportServer..ReportSchedule RSS ON RC.ItemID = RSS.ReportID
AND RSS.SubscriptionID = RS.SubscriptionID
SSRS schedule details was last modified: October 1st, 2017 by Justin Antony

About Justin Antony

Leave a Reply