How to get run time for job total run time from history.
USE MSDB;
GO
select
j.name as 'JobName',
run_date,
run_time,
CONVERT(CHAR(8),DATEADD(second,run_time,0),108) AS Total_Run_Time,
h.message
From msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobhistory h
ON j.job_id = h.job_id
where j.enabled = 1 --Only Enabled Jobs
and j.name = '
JOB_Name_Make_Change'
order by run_date desc