SQL Agent Job Running Status
IF EXISTS( SELECT 1 FROM msdb . dbo . sysjobs J JOIN msdb . dbo . sysjobactivity A ON A . job_id = J . job_id WHERE J . name = N'Your Job Name' AND A . run_requested_date IS NOT NULL AND A . stop_execution_date IS NULL ) PRINT 'The job is running!' ELSE PRINT 'The job is not running.'