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.