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

• dvprao

  Ten Centuries

  Points: 1311

  More actions

  August 5, 2013 at 12:16 pm

  #278322

  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