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/