DECLARE job_id CURSOR
FOR
SELECT      job.job_id
FROM      msdb.dbo.sysjobs_view job
JOIN
    msdb.dbo.sysjobactivity activity
	ON     job.job_id = activity.job_id
JOIN
    msdb.dbo.syssessions sess
	ON     sess.session_id = activity.session_id
JOIN
(
    SELECT
        MAX( agent_start_date ) AS max_agent_start_date
    FROM
        msdb.dbo.syssessions
) sess_max
ON
    sess.agent_start_date = sess_max.max_agent_start_date
WHERE 
    run_requested_date IS NOT NULL AND 
    stop_execution_date IS NULL 
	AND    job.name IN (N'job1', N'job12')

OPEN job_id

DECLARE @Job_id UNIQUEIDENTIFIER

FETCH FROM job_id INTO @Job_id
WHILE @@FETCH_STATUS = 0
BEGIN
	
	EXEC dbo.sp_stop_job @job_id = @Job_id
	
FETCH FROM job_id INTO @Job_id
END
CLOSE job_id
DEALLOCATE job_id