CODEWITHSUNDEEP
sql-serverreporting-servicesjobs
Glen
Glen

Reputation: 830

Stop long running SSRS Subscription Job

Anyone know how to stop a long running SSRS Subscription Job that is supposed to be pushing reports out to a UNC path but it had a bug and it is not pushing anything however it is still checking but failing on each row of the dataset.

The following is the closest I have to finding a solution: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ce552f9b-c1c5-4a23-bd1d-0525d9342449/stop-a-running-ssrs-subscription?forum=sqlreportingservices

Which isn't really that close as on the server box itself I was able to logon to however their are no jobs showing so there is nothing to cancel. I also tried restarting the SSRS server via Configuration Manager but to know avail.

I should also mention I prefer not to delete the Subscription and see if it works and create a new one but looks like I might have to try that.

Upvotes: 1

Views: 9632

Answers (2)

Phill
Phill

Reputation: 1

1) Ive restarted ssrs. 2) cancelled the jobs on SSRS reports database. 3) emptied the data table with subscription data in it. BUT when i look in activity monitor the SSRS subscription is still running threads and i can see that it is exactly the same sql as entered into the SSRS report that is part of the subscription... In a nut shell, everything is first pumped into memory and the subscription will keep running until all the data in memory has been processed through the SSRS system/ even though you have cancelled the running SSRS job.

Upvotes: 0

GandRalph
GandRalph

Reputation: 635

The link is correct.

In SSMS click Connect and "Reporting Services": enter image description here

Expand the newly added node and expand the Jobs node. Right click the required job and click cancel. If there are no Jobs displayed then no jobs are running.

Upvotes: 2

Related Questions