Below is a quick script to convert the run_duration column into 3 separate columns for Hours, Minutes, and seconds. The script will also convert the run_date column to a date. Useful for dropping into Excel and running reports.
SELECT runDate = CONVERT (DATETIME, RTRIM(run_date)), run_duration/10000 Hours, --hours run_duration/100%100 Minutes, --minutes run_duration%100 Seconds --seconds from sysJobHistory
Just add a job_id in your where clause if you want to track a single job. I used this script to generate a report of run times for a specific job. We had a SQL job run long (so we thought) and wanted to drill into the numbers a bit. After some investigation we discovered that the job was pretty consistent and that the long run time was consistent with the job history.
You can also just combine the hours, minutes, and seconds into 1 column like so:
SELECT runDate = CONVERT (DATETIME, RTRIM(run_date)),CAST(run_duration/10000 as varchar) + ':' + CAST(run_duration/100%100 as varchar) + ':' + CAST(run_duration%100 as varchar) from sysJobHistory