Post reply

SQL 2005 SP2 - Report Server "Subscriptions" stoppped executing

  • July 13, 2009 at 1:02 pm

    #132043

    Subscriptions worked for a while then they all stopped for some reason. Last run was two weeks ago. I changed the execution time to check but they still did not run. Some send a .pdf attach and some render html but all send via email. The server can reach the smtp email server and a test vbscript was able to send/relay email.

    Short of recreating these, what should I look for?

    They did run before and there was no change other than physiaclly moving the server from one rack to the other at the data center.

    Thanks

  • July 13, 2009 at 2:55 pm

    #1024149

    Solution found.

    We cycled the "SQL Server Agent".

    Apparently Report Server uses the SQL Agent to trigger your subscriptions.

    I personally looked for the in the SQL gaent Job folder and there's nothing. It just might be a small subset of tasks for SQL agent the we can not or are not allowed to see.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply