Graph MSSQL Job Start Time And Duration

**reckless** · 04-23-2009, 01:30 PM

Hi!

I would like to create a Chart with start time and duration of MSSQL job history over 24 hours. The purpose of this is to show what job is running, at what time and for how long, so we can optimise the scheduling and make sure not tasks runs at the same time. I'm not sure wich type of graph is best and how to set up the data. Can you help me getting started? Here's a sample data...

**teylyn** · 04-23-2009, 07:51 PM

Hi,

this is really difficult to chart, since you have data that spans a 24hr time frame and jobs that run for only a few seconds. You can chart it with a stacked bar graph, taking only two columns into the graph: the last run time and the last run duration stacked on top of each other. Then format the bars for the last run time with no border and no fill color, which leaves you with the run duration floating. Add column A as your categories to the chart. But, as I said before, since most jobs are only a few seconds long, they won't even occupy a pixel in your graph, so they won't be plotted at normal resolution. You may want to break up the data into hourly chunks and graph by hour, but even then, with a very wiiiiiiide graph, you'll only see a thin line for a job of a few seconds.

**reckless** · 04-23-2009, 08:33 PM

Thaks for you're help! I've never though about a stacked bar Graph. Of course, jobs that runs in a few seconds are not as much as a concern for me, so I might just forget about the one that are recuring to often. But most important, you got me on the right track. Very appreciated.