[CR #326255] The Job Scheduler Agent cannot terminate a job on request.
Workaround:
Retrieve the spid and target server name from the stored procedures used in the job you want to terminate. The GUI displays this information.
List all running jobs by scheduled job name:
sp_sjobhelp @name='sjname=<sjob name>', @option='all_users,running' go
The following values are returned:
runid – the xid.
server – the target server name.
job start – when the job started.
user_run – the name of the user running the job.
List all running jobs by job name:
sp_sjobhelp @name='jname=<job name>', @option='all_users,running' go
The following values are returned:
runid – the xid
server – the target server name
job start – when the job started
user_run – the name of the user running the job
Log on to the target server.
Use sp_who to check that the job you want to terminate has the spid associated with the user_run you expect.
Terminate the job. Enter:
kill spid