exec msdb.dbo.sp_help_job

;with JobHistory
as
(
select
	j.name
	, replace(convert(varchar, convert(datetime, cast(jh.run_date as varchar), 102), 102), '.', '-')
		+ ' ' 
		+ left(right('000000' + cast(jh.run_time as varchar), 6), 2) + ':'
		+ substring(right('000000' + cast(jh.run_time as varchar), 6), 3, 2) + ':'
		+ right(right('000000' + cast(jh.run_time as varchar), 6), 2) as RunDate
	, case jh.run_status
		when 0 then 'Failed'
		when 1 then 'Succeeded'
		when 2 then 'Retry'
		when 3 then 'Canceled'
		end as RunStatus
	, row_number() over(partition by jh.job_id order by jh.[instance_id] desc) as RN
from msdb.[dbo].[sysjobhistory] jh
join msdb.dbo.sysjobs j on jh.job_id = j.job_id
where run_date >= cast(convert(varchar, getdate(), 112) as int) - 1
and jh.step_id = 0
--and jh.run_status <> 1
	)
select
	name
	, RunDate
	, RunStatus
from JobHistory
where RN = 1
--and RunStatus <> 'Succeeded'
order by RunDate desc