Get SSIS Package status

CREATE PROC [dbo].[GetPacakgeStatus]
		@sqlAgentJobName VARCHAR(100)		
AS
BEGIN 	

--- ***************************************************
--- *************************************************** 	
--- ***************** NOT USED ANYMORE ****************	
--- ***************************************************
--- *************************************************	
SET NOCOUNT ON;				
			-- -1 = Job is Disabled
			--  0 = Failed
			--  1 = Succeeded
			--  2 = Retry
			--  3 = Canceled
			--  4 = In progress
			--  5 = Disabled
			--  6 = Idle	
		
		SELECT systemJob.job_id, systemJob.name,		
			(CASE
				WHEN systemJob.enabled = 0 THEN -1
				WHEN systemJobActivity.run_requested_date IS NULL THEN 6
				ELSE ISNULL(systemJobHistory.RUN_STATUS, 4)
			END) STATUS , 
			systemJobHistory.retries_attempted,systemJobHistory.[message]        
		FROM MSDB.DBO.SYSJOBS systemJob
		INNER JOIN MSDB.DBO.SYSJOBACTIVITY systemJobActivity ON (systemJob.job_id = systemJobActivity.job_id)
		INNER JOIN (SELECT MAX(SESSION_ID) AS SESSION_ID FROM MSDB.DBO.SYSSESSIONS ) AS S ON (systemJobActivity.session_ID = S.SESSION_ID)
		LEFT JOIN MSDB.DBO.SYSJOBHISTORY systemJobHistory ON (systemJobActivity.job_history_id = systemJobHistory.instance_id)
		WHERE systemJob.name = @sqlAgentJobName