Check if SSIS Job is Running

IsSSISJobRunning.sql

DECLARE @JOB_NAME SYSNAME = N'Daily update of indexes & statistics'; 
 
IF NOT EXISTS(     
        select 1 
        from msdb.dbo.sysjobs_view job  
        inner join msdb.dbo.sysjobactivity activity on job.job_id = activity.job_id 
        where  
            activity.run_Requested_date is not null  
        and activity.stop_execution_date is null  
        and job.name = @JOB_NAME 
        ) 
BEGIN      
    PRINT 'Starting job ''' + @JOB_NAME + ''''; 
    EXEC msdb.dbo.sp_start_job @JOB_NAME; 
END 
ELSE 
BEGIN 
    PRINT 'Job ''' + @JOB_NAME + ''' is already started '; 
END 

thanks to http://gallery.technet.microsoft.com/scriptcenter/Check-if-a-SQL-Server-75b889b4