check sql job is running or not

SELECT





case h.run_status

when 0 then 'Failed '

when 1 then 'Succeeded '

when 2 then 'Retry (step only)'

when 3 then 'Canceled'

when 4 then 'In-progress message '

when 5 then 'Unknown'

end as [run status ]





FROM

msdb.dbo.sysjobhistory h

INNER JOIN

msdb.dbo.sysjobs_view j

on h.job_id = j.job_id

where

j.name = 'job name'

AND run_status in (0,1,2,3,4) -- Failed, cancelled, in prog, unknown


group by run_status