Job Failed Query

SELECT Job.server ServerName,
       SysJobs.name JobName,
       SysJobSteps.step_name StepName,
       Job.run_status RunStatus,
       Job.message ErrorMessage,
       Job.ExecDate RunDate,
       Job.run_duration RunTime
FROM
(
    SELECT Instance.instance_id,
           DBSysJobHistory.job_id,
           DBSysJobHistory.step_id,
           DBSysJobHistory.sql_message_id,
           DBSysJobHistory.sql_severity,
           DBSysJobHistory.message,
           (CASE DBSysJobHistory.run_status
                WHEN 0
                THEN 'Failed'
                WHEN 1
                THEN 'Succeeded'
                WHEN 2
                THEN 'Retry'
                WHEN 3
                THEN 'Canceled'
                WHEN 4
                THEN 'In progress'
            END) AS run_status,
           ((SUBSTRING(CAST(DBSysJobHistory.run_date AS VARCHAR(8)), 5, 2)+'/'+SUBSTRING(CAST(DBSysJobHistory.run_date AS VARCHAR(8)), 7, 2)+'/'+SUBSTRING(CAST(DBSysJobHistory.run_date AS VARCHAR(8)), 1, 4)+' '+SUBSTRING((REPLICATE('0', 6-LEN(CAST(DBSysJobHistory.run_time AS VARCHAR)))+CAST(DBSysJobHistory.run_time AS VARCHAR)), 1, 2)+':'+SUBSTRING((REPLICATE('0', 6-LEN(CAST(DBSysJobHistory.run_time AS VARCHAR)))+CAST(DBSysJobHistory.run_time AS VARCHAR)), 3, 2)+':'+SUBSTRING((REPLICATE('0', 6-LEN(CAST(DBSysJobHistory.run_time AS VARCHAR)))+CAST(DBSysJobHistory.run_time AS VARCHAR)), 5, 2))) AS ExecDate,
           DBSysJobHistory.run_duration,
           DBSysJobHistory.retries_attempted,
           DBSysJobHistory.server Server
    FROM msdb.dbo.sysjobhistory DBSysJobHistory
         JOIN
    (
        SELECT DBSysJobHistory.job_id,
               DBSysJobHistory.step_id,
               MAX(DBSysJobHistory.instance_id) AS instance_id
        FROM msdb.dbo.sysjobhistory DBSysJobHistory
        GROUP BY DBSysJobHistory.job_id,
                 DBSysJobHistory.step_id
    ) AS Instance ON DBSysJobHistory.instance_id = Instance.instance_id
    WHERE DBSysJobHistory.run_status <> 1
) AS Job
JOIN msdb.dbo.sysjobs SysJobs ON(Job.job_id = SysJobs.job_id)
JOIN msdb.dbo.sysjobsteps SysJobSteps ON(Job.job_id = SysJobSteps.job_id
                                         AND Job.step_id = SysJobSteps.step_id)
WHERE Job.ExecDate > DATEADD(DD, -1, GETDATE())
      AND Job.run_status LIKE 'failed';