Sample Header Ad - 728x90

Need to urgently stop a data driven subscription from sending a multitude of emails

0 votes
1 answer
282 views
can someone please help me so that I can have a job tomorrow. Fairly new at this and I've searched and tried several suggestions on this site to no avail. I made an error in my data driven script and now it's emailing me constantly. It's only a matter of time before our security department comes down on me. I can see the job ID but I don't see the subscription as running under SSMS Job Activity Monitor. I've disabled the job under Subscriptions in SSRS. How can I stop the emails? It's sending batches every second. I can turn off the MSSQLSERVER service and it temporarily stops, likewise I can set the IsSchedulingService in the rsreportserver.config file and it temporarily stops, but what is driving the constant emails? I'm at a loss. Any help appreciated.
Asked by Wondering (1 rep)
Sep 17, 2023, 05:32 PM
Last activity: May 19, 2025, 02:01 PM