Method 1:
System Stored procedure: sp_help_job, returns information on the job, its steps, and more.
EXEC msdb.dbo.sp_help_job @Job_name = ‘Your Job Name’
Method 2:
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.’