We have Reporting Svcs 2012 running in SharePoint integrated mode (SharePoint 2013).

For one of our reports, we have a subscription set up that uses a shared schedule that is supposed to run every quarter - so we use Monthly run with feb-May-Aug-Nov selected. Somehow the report runs every month instead of every quarter. It was not supposed to run in September, but it still did. We checked the scheduled job on Reporting Db server and it looks all good with 4 schedules for each selected month.

Has anyone seen this issue? If yes, what could be going wrong? We are planning to delete and re-add the schedule to see if that fixes the issue.

Thanks,

Sonal

Hi Sonal,

Check this thread

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e2fa3c64-5158-4137-8fcc-236d3a9f582c/ssrs-subscription-schedule?forum=sqlreportingservices

Thanks for your post Milan. These were the exact steps we followed to set up the schedule. Somehow it is not working. Somehow monthly part overrides month selection. :(

What should we check in Reporting Services database to see what could be going wrong? How do we check individual runs with schedule details.

Thanks,

Sonal