February 9, 2016 at 3:35 am
Hi Everyone.
I have a SQL Server 2008 RS installation, on which there are a small number of subscriptions.
Increasingly, recently, these have stopped delivering.
The entries are in the Notifications table sometimes hours after the schedule has fired but I can't work out why.
Do you have any advice on where I can look to find out why they are being held back?
Many thanks
Paul J
March 1, 2016 at 12:39 pm
One thing to make sure is to not schedule multiple subscriptions for the same report to run all at the same time. This could cause a series of issues including deadlocking.
If that is not your issue you can reference SQL Job history on the SSRS server / Event Viewer. Just match up your subscription run times.
Lastly you can check the SSRS log files on the SSRS server:
C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply