SQL Server Agent job status web part for SharePoint

I have released a small web part for SharePoint that displays the current status of a SQL Server Agent job as a colored icon and displays status messages as text.

The solution and the source code is available at:

http://jobstatus.codeplex.com

Here is a screenshot of how it might look in a standard SharePoint 2007 team site.

screenshot_JobStatus

Why would anyone want this?

Sometimes SQL Server Agent jobs take some time to complete and other systems might rely on that job to complete before any useful information can be extracted from them. One example is slow import jobs done through an agent job. To be able to provide the user with the status means they know if the jobs are done or not.

This is available for download and immediate use free of charge from the codeplex site, no programming needed if you are happy with the current implementation. The source code is quite uncomplicated and anyone should be able to rework it if needed.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.