SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to stop a subscription that seem to be running as per dbo.runnigjobs table in SSRS 2005 ?


How to stop a subscription that seem to be running as per dbo.runnigjobs table in SSRS 2005 ?

Author
Message
dvprao
dvprao
SSC Veteran
SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)

Group: General Forum Members
Points: 288 Visits: 151
I have this problem report that seem to be running multiple times and none of them complete and seem to be stuck. Dud to the hard coded thread limit of 4 reports for core , the queue if longer than 32 ( in my case ) , seem to be affecting other subscriptions as well. So I want to kill the long running subscriptions. Is there a way I can do that gracefully ?
------------------
Recycling the SSRS Box is one option , but since the subscription is not updated as completed, the run seem to start again ( 3 times). Other than waiting for the timeout value to elapse , I do not see any other option.
-------------------------------
see a sample as below:
------------------------------------------------------------------------------------------------------

JobID StartDate
2jjuhz45yykv0bbympcsirru 2013-08-05 07:34:52.137
2q5itjaojp0mlyq3bi03fnab 2013-08-05 07:34:52.057
4cf1vjzlccsjjjzjvf5zzz45 2013-08-05 07:34:52.057
5h4rammq3vxjkti3n1xqaj55 2013-08-05 07:27:25.680
apgqp155uvlmu545xfw1uj55 2013-08-05 07:34:52.073
cdgmptzk5f3ajb45peo0k2mx 2013-08-05 10:32:03.173
e1rxfu55kxih3k55aexvth45 2013-08-05 07:34:52.090
i4ny5055xut5gbqedoyysl55 2013-08-05 07:34:52.057
j5dzxg45vrogmtjpzbnmiszq 2013-08-05 07:34:52.027
lspo3xnna3o45p45zwufry2s 2013-08-05 07:37:40.753
mo3bbr454pfqv3qzq4zha045 2013-08-05 07:56:57.407
mosjjd454dh51uzr25tcbq55 2013-08-05 07:26:40.493
qwyurv55pv55ae55m0da45vi 2013-08-05 07:34:52.057
rdtx4d45y2zaw13cteyx2o55 2013-08-05 07:39:30.867
rsorttilqdfjux55driy4345 2013-08-05 07:42:31.060
s0nclxnl3fwexgzyzlgrf1yx 2013-08-05 07:27:15.523
u3lfht45zpw3ol55e0kwfi45 2013-08-05 10:32:58.003
zrnnypergmob1q55c0wfc3nu 2013-08-05 07:37:43.893
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search