Subscription email stalling

  • 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

  • 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