I actually figured out how to do it by utilizing a CTE table to bring in msdb.dbo.sysjobacivity. Then inserting that into a memory table and joining back to that in...

Very much appreciated. I did change the Cast to a convert. However the Continuous_Start_DTM doesn't appear to work as anticipated. I only included some of the columns in the...

Lynn,

I read the article on the tally tables and also worked though all of the examples. I do understand how tally tables are much faster than creating loops. However, there...

Hey Jeff- Correct. It is the duration of the SQL job in Seconds.

Lynn - I will check out the links and see what I can do!

Thanks to both for your...