Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to stop a subscription that seem to be running as per dbo.runnigjobs table in SSRS 2005 ? Expand / Collapse
Author
Message
Posted Monday, August 5, 2013 12:16 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, December 9, 2013 5:59 PM
Points: 83, Visits: 96
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
Post #1481031
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse