Sharepoint / SSRS subscriptions intermittently not emailing
I am running MOSS with SQL Server 2005 Reporting Services in integrated mode. There are a number of reports that are generated and then output emailed through SharePoint's subscriptions. Sporadically all subscriptions will fail to email with the error message of "Failure sending mail: Report Server has encountered a SharePoint error."
Can any one shed any light as to why this is occuring and what I can do to prevent it?
Solution 1:
To see the status of your subscriptions and when they last executed, you can perform a query: http://feedproxy.google.com/~r/sqlserverpedia/~3/O78C3knsUO0/