Script for SQL Job failures

SELECT  cast(serverproperty('Machinename') as varchar(255)) Servername,isnull(cast(serverproperty('Instancename') as varchar(255)),
cast(serverproperty('Machinename') as varchar(255))) Instancename,
    j.name AS JobName,
    Isnull(Substring(CONVERT(VARCHAR(8), js.last_run_date), 1, 4) + '-' +Substring(CONVERT(VARCHAR (8), js.last_run_date), 5, 2) + '-' +  Substring(CONVERT(VARCHAR( 8), js.last_run_date), 7, 2), '') AS [Run DATE]
         ,CASE
        WHEN j.enabled = 1 THEN 'Enabled'
        ELSE 'Disabled'
    END JobStatus
    ,CASE
        WHEN js.last_run_outcome = 0 THEN 'Failed'
        WHEN js.last_run_outcome = 1 THEN 'Succeeded'
        WHEN js.last_run_outcome = 2 THEN 'Retry'
        WHEN js.last_run_outcome = 3 THEN 'Cancelled'
        ELSE 'Unknown'
    END JobRunStatus
FROM msdb.dbo.sysjobs j
JOIN msdb.dbo.sysjobservers js on js.job_id = j.job_id
where j.name in('DatabaseBackup - SYSTEM_DATABASES - FULL',
'DatabaseBackup - USER_DATABASES - DIFF',
'DatabaseBackup - USER_DATABASES - FULL',
'DatabaseBackup - USER_DATABASES - LOG','DatabaseIntegrityCheck - SYSTEM_DATABASES',
'DatabaseIntegrityCheck - USER_DATABASES',
'IndexOptimize - USER_DATABASES','Update Log Growth Setting',
'UpdateStats CUSTOM DAILY - USER_DATABASES')-- and j.enabled=1
ORDER BY j.name, js.last_run_date, js.last_run_time