select
		sjh.instance_id,
		cast(cast(sjh.run_date as varchar(32)) + ' ' + stuff(stuff(right(replicate('0', 6) +  cast(sjh.run_time as varchar(6)), 6), 3, 0, ':'), 6, 0, ':') as datetime) as hr_run_time,
		job_name = sj.[name],
		sjh.step_name,
		case sjh.run_status when 0 then 'ошибка' when 1 then 'успешно' when 2 then 'повтор' when 3 then 'отмена' end as [status],
		(sjh.run_duration / 10000)  * 60 * 60 + ((sjh.run_duration / 100) % 100) * 60 + (sjh.run_duration % 100) as run_duration_sec,
		sjh.retries_attempted,
		sjh.[server],
		sjh.[message]
from
		msdb.dbo.sysjobhistory sjh
		join
		msdb.dbo.sysjobs_view sj
			on sj.job_id = sjh.job_id
where
		sjh.run_date >= convert(varchar, dateadd(dd,-2,getdate()), 112)
		and sjh.run_duration >= 60
		--and (sj.[name] = 'СмотримИнтересующийДжоб')
order by
		sjh.instance_id desc;