djj (3/10/2014)
Why not modify the first query to LEFT JOIN to msdb..Sysjobhistory?
Thanks.
I will need a LEFT JOIN on sysjobs because I want them to show up regardless if they have run or not.
The Jobs do not show up until the job completes. I would like the start time of the jobs that have started but have not yet finished.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/