March 3, 2011 at 3:58 am
We're on SSRS 2008 and have a large number of scheduled reports, mostly to send out emails containing links or attachments. In the last couple of weeks the reports have been coming out several hours later than scheduled - and often in a big batch.
Since Monday this week the scheduled reports are not being sent out at all. I have tried deleting and recreating subscriptions, but this doesn't work. Curiously, on the deleted and recreated subscriptions the Last Run time is shown as the expected scheduled time, but the status remains as 'New Subscription', even after the report subscription claims to have run.
The issue is not just related to email, as writing to a shared file location shows the same symptoms.
Any help would be greatly appreciated, as we're really struggling with this.
Many thanks
Jonathan
March 3, 2011 at 4:07 am
The scheduled reports are implemented by SqlAgent jobs.
Is SQLAgent running on the machine ? Is there any thing of relevance in the Agent error log ?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply