Search results matching tags '2008' and 'PowerPivot'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=2008,PowerPivot&orTags=0Search results matching tags '2008' and 'PowerPivot'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Power Pivot SQL Agent Job Monitorhttp://sqlblog.com/blogs/davide_mauri/archive/2013/01/07/power-pivot-sql-agent-job-monitor.aspxMon, 07 Jan 2013 21:23:29 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47058manowar<p>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 <em>sysjob</em> 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).</p> <p>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.</p> <p>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.</p> <p>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:</p> <p><a title="http://jobmonitor.codeplex.com/" href="http://jobmonitor.codeplex.com/">http://jobmonitor.codeplex.com/</a></p> <p>Enjoy!</p>