DECLARE @Date datetime
SET @Date = DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

SELECT j.name as [Job Name],
h.step_name AS [Job Step Name],
CASE j.enabled WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END AS [Enabled],
CONVERT(CHAR(10), CAST(STR(h.run_date,8, 0) AS dateTIME), 111) as [Run Date],
STUFF(STUFF(RIGHT('000000' + CAST ( h.run_time AS VARCHAR(6 ) ) ,6),5,0,':'),3,0,':') as [Run Time],
STUFF(STUFF(RIGHT('000000' + CAST ( h.run_duration AS VARCHAR(6 ) ) ,6),5,0,':'),3,0,':') as [Step Duration],
case h.run_status when 0 then 'Failed'
when 1 then 'Succeded'
when 2 then 'Retry'
when 3 then 'Cancelled'
when 4 then 'In Progress'
end as [Execution Status],
h.message as [Message Generated]
FROM msdb.dbo.sysjobs j inner join  msdb.dbo.sysjobhistory h
ON j.job_id = h.job_id
where h.run_status = 0 AND msdb.dbo.agent_datetime(h.run_date, h.run_time)> @Date AND j.name like '%MAINTENANCE - BACKUP%'