Affichage des travaux à l'exécution la plus longue :

SELECT
	j.name AS JobName,
	sjh.run_duration AS Duration_HHMMSS,
	sjh.run_status, 
	sjh.run_date, 
	--RIGHT('000000'+CAST(sjh.run_time as varchar(6)), 6) as run_time,
	LEFT(RIGHT('000000'+CAST(sjh.run_time AS varchar(6)), 6), 2) + ':' 
		+ SUBSTRING(RIGHT('000000'+CAST(sjh.run_time AS varchar(6)), 6), 3, 2) + ':' 
		+ RIGHT(RIGHT('000000'+CAST(sjh.run_time AS varchar(6)), 6), 2) AS run_time2
FROM msdb.dbo.sysjobhistory sjh
JOIN msdb.dbo.sysjobs_view j ON sjh.job_id = j.job_id
WHERE 
	sjh.run_duration > 60 AND 
	sjh.step_id = 0
ORDER BY run_duration DESC