I have an SSRS report in SharePoint 2010, there was an alert set to send every minute regardless of whether the data changed. This alert was deleted, then the report was deleted, but its still sending the email. After the report was deleted it was still emailing the alert but the email contained an error message saying that the report cannot be found and not the actual report.
I have checked the
User Alerts under
Site Admin and
Manage Data Alerts in
Reporting Services, both are empty. I have checked the alerts for the specific report as well.
Is there any way of stopping this?
It seems that alerts don't work as I expected them to.
When an alert is triggered it writes a record to a log, it is not sent immediately. The job that sends the email alerts runs periodically, every 5 minutes by default, and picks up all the alerts that need to be sent and sends them. As the alert was created about 2 months ago so there is approx 90,000 emails in the log waiting to be sent so until this clears the emails will continue to be sent.
The article The truth about how daily SharePoint alerts actually work by Chris Domino describes this pretty well
So now my question is how to clear the "log"?