kill a Job

  • How can I cancel a Job that has been running for 10hrs already?

    I tried to kill the processID but the process still running. It is a SSIS package that is running as a (CmdExec) through SQL Agent.

    any idea?

  • In the Job manager, right-click and select "Stop". Or did you already try that?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • oh that was easy.. I wasnt sure about the option cause in the Job I have 4 steps..

    but it worked for me..

    Thank you very much !

  • You're welcome.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply