Hi Lynn,

I can't remember where I got hold of this script but it does the conversion as you've asked:

SELECT J.[name] JobName

, J.[description] JobDescription

, CONVERT(DATETIME, Cast(S.next_run_date AS VARCHAR), 112) AS NextRunDate

, Datename(dw, CONVERT(DATETIME, Cast(S.next_run_date AS VARCHAR), 112)) AS NextRunDate_Day

, S.next_run_time AS NextRunTime

, (SELECT Min(run_time)

FROM msdb.dbo.sysjobhistory H

WHERE H.job_id = J.job_id) AS Duration_MIN

, (SELECT Avg(run_time)

FROM msdb.dbo.sysjobhistory H

WHERE H.job_id = J.job_id) AS Duration_AVG

, (SELECT Max(run_time)

FROM msdb.dbo.sysjobhistory H

WHERE H.job_id = J.job_id) AS Duration_MAX

FROM msdb.dbo.sysjobs J

LEFT JOIN msdb.dbo.sysjobschedules S

ON J.job_id = S.job_id

WHERE J.[Enabled] = 1