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
Sunday, February 19, 2012
How to stop running subscriptions??
Labels:
cancelrunningjobs,
database,
included,
microsoft,
mysql,
oracle,
rss,
running,
samples,
script,
server,
sql,
subscription,
subscriptions
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment