SSRS subscriptions still firing off after deleting them

Question

SSRS subscriptions still firing off after deleting them

J M-314995

SSCrazy

Points: 2975
More actions
January 24, 2019 at 3:23 pm

#382642

Hello,
We recently upgraded our CRM which also included an upgrade on our SQL server. version and the OS it runs on.
We were on SQL Server 2008 Standard. We used SSRS and subscriptions to fire off reports daily/weekly/monthly. After our upgrade, I downloaded all of the SSRS subscriptions and then uploaded them to the new SQL 2016 server. I then went in and deleted all the subscriptions using the UI. I then checked the Subscriptions table and none of the subscriptions were present. I continued to get reports from that server. I then went in and removed the smtp settings in the Reporting Services Configuration manager and I still got messages. A few minutes ago, I disabled the SSRS service altogether.
I'm hoping that stopping the service works so my question is why am I still getting SSRS reports from that old server? Is there someway the reports I uploaded to the new server are querying the old server even though the data sources only point to the new server? I opened up one of the RDL files to take a peek and it looks like those only look at data sources.
I'm just baffled as to why these reports are still running after I deleted the subscriptions....then removed the smtp server settings.
TIA,
John

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

J M-314995 SSCrazy Points: 2975 More actions · Answer 1

So that I can narrow down what fixes it, I've re-enabled the SSRS service but I disabled the SQL jobs that corresponded to the subscriptions. I'll find out tomorrow morning if that worked.

Sue_H SSC Guru Points: 90860 More actions · Answer 2

J M-314995 - Thursday, January 24, 2019 4:11 PM
So that I can narrow down what fixes it, I've re-enabled the SSRS service but I disabled the SQL jobs that corresponded to the subscriptions. I'll find out tomorrow morning if that worked.

Then something didn't go right when you deleted the subscriptions.
When you delete the subscription, it cascades through a few deletes starting with the delete trigger on the subscription table. In the process, it gets to where it deletes from the Schedule table and the trigger on that table deletes the agent job. So if the job still existed, it didn't cascade down through the process. Could be that one of the deletes didn't succeed due to some modifications that could have been made or the jobs were changed outside of reporting services.
If you have the reporting services logs for around the time you deleted the subscriptions, those may tell you something or if you had system issues of some sort when you deleted the subscriptions. .

Sue

J M-314995 SSCrazy Points: 2975 More actions · Answer 3

Thank you for your response Sue. I appreciate it.

I'm still getting reports from the old server even after disabling the SQL jobs that ran last night. I knew that there was another one scheduled a few minutes ago so I disabled SSRS services altogether and it still ran.

I'm not sure what could've gone wrong when I originally deleted the subscriptions but I'll see if the logs exist from back in November.

At this point, I'm guessing that the rdl files that I downloaded from the old server and uploaded to the new server are causing this. I'm not sure how that's possible given that there are no data sources on the new server pointing to the old server.

We're going to decommission this server in 3-4 months but I need to stop the subscriptions that are still taking place.

TIA,
John

Sue_H SSC Guru Points: 90860 More actions · Answer 4

J M-314995 - Friday, January 25, 2019 9:39 AM
Thank you for your response Sue. I appreciate it.
I'm still getting reports from the old server even after disabling the SQL jobs that ran last night. I knew that there was another one scheduled a few minutes ago so I disabled SSRS services altogether and it still ran.
I'm not sure what could've gone wrong when I originally deleted the subscriptions but I'll see if the logs exist from back in November.
At this point, I'm guessing that the rdl files that I downloaded from the old server and uploaded to the new server are causing this. I'm not sure how that's possible given that there are no data sources on the new server pointing to the old server.
We're going to decommission this server in 3-4 months but I need to stop the subscriptions that are still taking place.
TIA,
John

You need to check the reporting services logs from your servers - from there you can see when subscriptions are firing.

Sue