Cancel specific collect background job

Answered

Rolf Haardoerfer

• March 25, 2019 20:42

Hi,

I am trying to stop a specific collect job in my background queue.

I have stopped the background process and cleared the queue but the job is still active. 

How can I do this?

Thanks,

Rolf

0

• Best answer

  

  Alyssa Sliney

  • March 29, 2019 11:30

  Hi Rolf,

  It needs to be killed on the SQL side. Killing something on the DSP side won't stop the SQL side from running but killing the SQL side should kill the job on the DSP side, as it will throw an error.

  You can run SP_Who2 or use Activity Monitor in SQL to find the SPID, the run the Kill command to stop the SQL process.

  If you have Collect configured to retry the job, it may kick off again automatically, so you may want to reset the table in Collect first as well.

  1

Please sign in to leave a comment.