SQL code to display job history using the query.
select
j.name as 'JobName',
msdb.dbo.agent_datetime(run_date, 0) as 'RunDateTime'
From msdb.dbo.sysjobs as j
INNER JOIN msdb.dbo.sysjobhistory h
ON j.job_id = h.job_id
where j.enabled = 1 --Only Enabled Jobs
order by JobName, RunDateTime desc
