Before I start poking around in the system tables, I figured that I would ask around on some forums first.
What I want to do it two things:
1. Show on a graph how long each one of my nightly jobs runs, scheduled through SQL Agent. Also I want to show on this graph where my jobs overlap and fight for resources.
2. Show on a graph cpu and disk usage for the time period when my nightly jobs run. I know that this info can be captured through the task manager and exported to SQL Server Reporting Services, but I haven't had time to set it up yet.
I want to compare the two graphs and see if I have any time 'hotspots' of the night and then I can move stuff around to get things done faster.
Does anyone know of any products out there that would help me out? I figured that I would ask around before I started developing my own process, hoping that someone else has already done this before.