Power Pivot SQL Agent Job Monitor

manowar — Mon, 07 Jan 2013 21:23:29 GMT

In the last days I needed a quick and efficient way to monitor the performance of a job and of each step over time. There’s a lot of interesting data in MSDB database and the various sysjob tables, but the stored data is not really easy to use outside the Management Studio. Date and Time are not stored as date/time data type, there is no easy way to correlate the performance of a step with the related job execution (for example is not that easy to return all the steps of a job executed, say, yesterday at 10:00).

So I decided to write some views to make the querying easier and then the next move was to create a Tabular Model with Power Pivot on Excel to make also analysis easier.

Since this is a somehow recurring task that I find myself doing during my job – not often, but when I have to do it now I have something much more powerful in my hands – I decided to put it also con CodePlex so that that little work can be shared with the community.

You can find the scripts with the objects (3 UDFs and 4 Views) that must be created inside MSDB and the Power Pivot Excel 2010 model here:

http://jobmonitor.codeplex.com/

Enjoy!

OT: We are hiring!

Denis Gobo — Wed, 07 Nov 2007 16:12:00 GMT

We are hiring in Princeton, New Jersey
If you know C#, SQL Server 2000/20005 and FoxPro then ping me at denis.gobo AT gmail.com and I can give you more details about this job. It is a full time position.

The good stuff

Your are unionized, you work 35 hours a week
You start out with 3 weeks vacation and 6 personal days
You have unlimited sick days
Excellent benefits
Work with billions of rows of data (always fun)
Work with SQL Server 2005 and C#
Work with me ;-)

The bad stuff

You have to work with FoxPro, you actually have to convert FoxPro legacy code to SQL and .NET

Search results matching tag 'Job'

Power Pivot SQL Agent Job Monitor

OT: We are hiring!