Will Alber has updated his free tool SQLjobvis. Download it from http://www.sqlsoft.co.uk/sqljobvis.php. It provides a graphical display of both running SQL Server Agent jobs as well as job history.
The SQLjobvis graphical display has been very effective in helping me explain why something must be scheduled when it is. Or why something can’t be scheduled at a particular time. I opened a Connect item https://connect.microsoft.com/SQLServer/feedback/details/524854/provide-a-graphical-interface-to-the-sql-server-agent-job-scheduler-and-history to encourage Microsoft to offer a better UI for scheduling jobs. Please vote if you haven’t already. I want to be able to graphically schedule jobs similar to how meetings can be graphically scheduled in Outlook. But until Microsoft offers us a better UI, SQLjobvis is making my life easier. It is the first thing I look at when I get to work in the morning.
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About John Paul Cook
John Paul Cook is a Technology Solutions Professional for Microsoft's data platform and works out of Microsoft's Houston office. Prior to joining Microsoft, he was a Microsoft SQL Server MVP. He is experienced in Microsoft SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. John is also a Registered Nurse who graduated from Vanderbilt University with a Master of Science in Nursing Informatics and is an active member of the Sigma Theta Tau nursing honor society. He volunteers as a nurse at safety net clinics. Contributing author to SQL Server MVP Deep Dives
and SQL Server MVP Deep Dives Volume 2
. Opinions expressed in John's blog are strictly his own and do not represent Microsoft in any way.