Jobs are not stopping when click on stop button of job. so I used follwing command to stop it.
SELECT j.name as
jobname
, j.*,ja.*
FROM msdb.dbo.sysjobactivity ja
JOIN msdb.dbo.sysjobs j
ON ja.job_id = j.job_id
WHERE ja.session_id = (SELECT TOP 1 session_id FROM msdb.dbo.syssessions ORDER BY agent_start_date DESC)
AND start_execution_date is not null
AND stop_execution_date is null;
Step 2-> Copy all rows in Excel.
Step 3-> look the DB name, Job execution time, Job started date etc.
Step 4-> Now select correct SPID and stop it.
USE msdb ;
GO
EXEC dbo.sp_stop_job
N'Job Name' ;
GO
--sp_who2
--kill -58-
Where 58 Is SPID which I want to stop.