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 SELECT RC.Name AS ReportName , RSS.ScheduleID AS JOB_NAME , RS.LastStatus , RS.LastRunTime , RS.[Description] FROM 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