Why don't you order by run_date and run_time select * from msdb..sysjobhistory order by run_date, run_time desc
Forum Rules