DECLARE @jname varchar(200);SET @jname = 'PUT YOUR SQL JOB NAME HERE'			-- faked parm
DECLARE @WithinTheLastNseconds int;SET @WithinTheLastNseconds = 6000			-- restrict to only jobs within this many seconds; recommended parm

DECLARE 
	@yyyymmddint int,
	@hhmmssch char(8),
	@hhmmssint int

SELECT @yyyymmddint = CONVERT(varchar(20),getdate(),112),@hhmmssch = CONVERT(char(8),DATEADD(second,-@WithinTheLastNseconds,getdate()),8)
SET @hhmmssint = SUBSTRING(@hhmmssch,1,2) + SUBSTRING(@hhmmssch,4,2) + SUBSTRING(@hhmmssch,7,2)


select sj.name,
	jh.instance_id,
	jh.run_date,
	jh.run_time,
	jh.step_id,
	jh.step_name,
	jh.message,
	jh.run_status,
	CASE jh.run_status
		WHEN 0 THEN 'Failed'
		WHEN 1 THEN 'Succeeded'
		WHEN 2 THEN 'Retry'
		WHEN 3 THEN 'Canceled'
		WHEN 4 THEN 'In progress'
		ELSE '-abnormal-' 
	END as run_status_desc
,jh.*
from msdb.dbo.sysjobhistory jh
inner join msdb.dbo.sysjobs sj ON jh.Job_ID = sj.Job_ID
where 
	jh.run_date = @yyyymmddint 
	and jh.run_time >= @hhmmssint
	and sj.name=@jname 
order by 
	sj.name,
	jh.instance_id