SELECT

STUFF(

STUFF(

RIGHT('000000' +

CAST(

[last_run_duration]

AS VARCHAR(6))

, 6)

, 3, 0, ':')

, 6, 0, ':')

AS [LastRunDuration]

FROM

[msdb].[dbo].[sysjobsteps]

INNER JOIN [msdb].[dbo].[sysjobs]

ON [sysjobsteps].[job_id] = [sysjobs].[job_id]

--WHERE [sysjobs].[name] ='??'

--AND [sysjobsteps].[step_id] = ??