All Current Jobs

SELECT percent_complete, estimated_completion_time, cpu_time, total_elapsed_time, READS,writes,logical_reads
,session_id,scheduler_id,start_time,status
FROM sys.dm_exec_requests
GO