Actually it's almost perfect except I put the max around the run_duration and grouped by job_id and run_date inside the LEFT JOIN.

from msdb.dbo.sysjobschedules SJ

join msdb.dbo.sysjobs...

Thanks so much! I haven't tried this yet but this should be very helpful.

Thanks... BUT - I forgot to include one important piece of information: I want the inner query to just grab the max run time... but let me give...