Query to find the Scheduled Job status in SQL Server

The below query displays the history of Job processed in the sql server for last 5 days. it display the job status failed/passed with processed date and jobname:


SELECT    CAST(CONVERT(datetime,CAST(run_date AS char(8)),101) AS char(11))    AS RunDate
        ,job_id
        ,step_name
        ,step_id
        ,[message]
        ,CASE WHEN run_status =1 Then 'Passed'ELSE'Failed' END AS JobStatus
        ,run_duration
        ,[server]
FROM    msdb..sysjobhistory
Where Run_date >= CONVERT(char(8), (select dateadd (day,(-5), getdate())), 112)
AND step_id != 0
ORDER BY run_status,run_date

Regards
Mahadevan