Have you ever needed to scroll through the Timer Job History in Central Administration? Wow, do a lot of jobs run! Nice that you can view 2,000 at a time, but even that’s not enough to scroll to a previous day’s Timer Job History. You can just jump into SQL Studio and use this query to extract the timeframe you want. I needed a two minute window almost three days ago, here’s the simple query, enjoy!
SELECT * FROM [SharePoint_Config].[dbo].[TimerJobHistory] WHERE starttime >'1/1/12 4:59:00'and EndTime <'1/1/12 5:01:00'