What's a good tool for visualizing SQL Agent jobs?

Question

I find the built-in MS SQL Studio tools for managing Agent jobs to be a little frustrating. What tools out there have you found helpful?

Offhand, there are three things I'd like to see in such a tool:

A graphical summary of which jobs ran when, for how long, and whether they succeeded.
A current status view, like the Job Activity Monitor, but refreshed in near-real time.
A more convenient interface for duplicating or modifying jobs (e.g., compare two job steps without being blocked by modal dialogs).

It would probably be simple to write a little app to handle this, but someone's surely already done it, and done it better.

This is obviously a subjective question, so if a mod of some sort wanders past, feel free to make it a CW.

MHG · Answer 1 · 2012-03-26 11:57:14Z

Did some googling around and here are some software that may interest you:

If anyone has more links to add, go ahead!

I gave SQLjobvis a try; it does let me visualize the schedule somewhat, but it's not really any better than what I could do for myself in an hour. I'd have put the time axis vertically, so users could easily scroll through the days.

yogirk · Answer 2 · 2012-02-29 07:20:08Z

up vote 1 down vote

Did you try reports feature?

Right click on SQL Agent => Reports => standard reports

answered Feb 29 '12 at 7:20

yogirk
91439

	I hadn't, but they're not terribly helpful. There are two, and they just show the number of executions and average run time. – Jon of All Trades Feb 29 '12 at 18:35
	To be clear, I'm not ruling out SQL Studio reports, if someone has a useful report they'd like to share. – Jon of All Trades Mar 7 '12 at 17:28

Henry Lee · Answer 3 · 2012-03-20 17:43:47Z

up vote 0 down vote

I'm not sure this satisfies all your criteria, but you might look at this:

answered Mar 20 '12 at 17:43

Henry Lee
67225

The web site makes me a little leery to run their .exe. Some contact information would be a start. – Jon of All Trades Mar 21 '12 at 22:22

stanleykylee · Answer 4 · 2013-03-19 13:18:23Z

Another one to add to the list:

One thing I like about this one is that it integrates with other components such as Windows Scheduler and Oracle tasks.

Thanks to Mark for bringing this up when I asked on The Heap.

4 Answers