ジョブのステップかかる時間抽出

USE MSDB
SELECT  LEFT(C.run_date,4)+'/'+substring(convert(varchar(8),C.run_date),5,2)+'/'+right(C.run_date,2) AS '運行時間'
 ,A.name
 ,C.step_id
 ,C.step_name
 ,(SELECT left(left(left('000000',6-len(run_duration))+ltrim(run_duration),2)+':'+right(left('000000',6-len(run_duration))+ltrim(run_duration),4),5)+':'+right(left('000000',6-len(run_duration))+ltrim(run_duration),2)) AS 'かかる時間'
FROM dbo.sysjobs A
INNER JOIN dbo.sysjobhistory C
ON A.job_id=C.job_id
WHERE  C.run_date=20100127
AND A.name='結果反映'