how to capture the schedule timings like suppose if the report is schedule monthly and every monday at 07:00 AM. I am generating a report which is for subscription details, where i am capturing all the subscriptions and their lastrun date and whether it is successed or failed and along with that i need to capture its respective schedule (time intervals) also.
asked Apr 23, 2012 at 01:15 PM in Default
You have to directly query tables in ReportServer database Here is the diagram:
Or you can use Michael Davis's diagnostic report http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69257/
answered Apr 23, 2012 at 02:22 PM