How do you stop data driven subscription in progress

• gissah

  SSCommitted

  Points: 1815

  More actions

  August 10, 2016 at 8:30 am

  #328865

  How do you stop data driven subscription in progress. Thanks

• gissah

  SSCommitted

  Points: 1815

  More actions

  August 10, 2016 at 10:55 am

  #1894859

  I delete the subscription and that solve it.

• karabocalvinthari

  Valued Member

  Points: 53

  More actions

  August 11, 2016 at 4:58 am

  #1894956

  Another way is to disable it using PowerShell command with the subscription ID in case you may need the subscription again in future.

• Thom A

  SSC Guru

  Points: 99143

  More actions

  August 17, 2016 at 2:29 am

  #1895857

  Surprised this wasn't mentioned, but if you log into RS in SSMS (windows Authentication only), you can stop the job there. Expand the Jobs folder and it will show all the current reports running, which can right click and stop. Among other things. This also avoids deleting the subscription, which probably isn't the best answer.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk