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.'