if object_id('tempdb..#t') is not null drop table #t
create table #t(job_id uniqueidentifier, 
last_run_date int ,
last_run_time int ,
next_run_date int ,
next_run_time int ,
next_run_schedule_id int ,
requested_to_run int ,
request_source int ,
request_source_id nvarchar( 200 ) ,
running int,
current_execution_step int ,
current_retry_attempt  int ,
current_execution_status  int )

insert #t EXECUTE master.dbo.xp_sqlagent_enum_jobs  1 , ''

select * 
from #t a
inner join msdb.dbo.sysjobs_view b on b.job_id = a.job_id
drop table #t