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.
RC.Name AS ReportName
, RSS.ScheduleID AS JOB_NAME
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