T-SQL (SS2K8) :: How To Return Jobs That Are In Progress

I have a query that returns the jobs that have completed for the nightly processing.

If I run the query it does not reflect jobs that are in progress.How can the following query be modified to reflect jobs that have started but have not completed?

SELECT DISTINCT j.Name AS Job_Name,
msdb.dbo.Agent_datetime(Run_Date, Run_Time) AS Run_Datetime,
Dateadd(second, Datediff(second, 0, msdb.dbo.Agent_datetime(19000101, Run_Duration)), msdb.dbo.Agent_datetime(Run_Date, Run_Time)) AS Run_Endtime,
Stuff(Stuff(RIGHT('000000'
+ Cast(Run_Duration AS VARCHAR(6)), 6), 5, 0, ':'), 3, 0, ':') AS Run_Duration,

[code]....