Job last run information

Use msdb
Go

Declare @job_id UniqueIdentifier
Select @job_id = Job_Id from sysjobs Where name='Job Name'
EXEC sp_help_jobserver @job_id = @job_id, @show_last_run_details = 1
Go