Can't Kill Job
Posted on 2007-07-30
SQL 2000 SP4 (8.0.2039) + Windows 2003 Enterprise x64 SP2 :
SQL Agent job hangs and I can't kill it with right-click 'stop job.' Is there any other way to kill the job without stopping the whole SQL service? I looked through individual SQL processes under Current Activity, and think I found the right one, but there is no column to identify the job - plus when I right-clicked and selected "kill job," it didn't work anyway.
I'm guessing that there is no way to kill this job through Windows, because all the jobs are running under the same sql process?