Showing posts with label samples. Show all posts
Showing posts with label samples. Show all posts

Sunday, February 19, 2012

How to stop running subscriptions??

Is there any way to stop a subscription once it has started?
Does the "CancelRunningJobs.rss" script included in the samples do this?
I have tried searching on here and on google and have not come up with much.
Thanks,
NickI did cancel a long runnig transactions with restarting the SQL Server
agent,
this ended up the Subscription and redering part of about 250 subscriptions.
HTH, JEns Süßmeyer
--
http://www.sqlserver2005.de
--
"Nick P @. INDATA" <NickPINDATA@.discussions.microsoft.com> schrieb im
Newsbeitrag news:152BEDCE-FC64-41DD-905C-B7C8727E441F@.microsoft.com...
> Is there any way to stop a subscription once it has started?
> Does the "CancelRunningJobs.rss" script included in the samples do this?
> I have tried searching on here and on google and have not come up with
> much.
> Thanks,
> Nick