Hi Jo.

I have seen that really large data sets dont get rendered right. Probably some limit in google visualisation?

This is a real timesaver, thanks for sharing 🙂

I stand corrected 🙂

Thx for the heads-up, and yes that line should have been commented out, since it is intended to be an option.

/***************************************************************************************

This script returns a (graphical) timeline for...

And here is the latest multi day version with the correct case this time (thx to alpinetrout)

/***************************************************************************************

This script returns a (graphical) timeline for all SQL jobs using google graph

****************************************************************************************

Version: ...

Good article,

But i have read several articles by i.e. Paul Randal en Jonathan Keyhayas that just taking 300 sec for PLE is no longer a good rule of thumb. This...

I have the same intermittent error when trying to to get to Win32_PerfRawData_PerfDisk_LogicalDisk

SET @output = ''

exec @OA_create_err=sp_OACreate 'WbemScripting.SWbemLocator', @WmiServiceLocator OUTPUT, 5

if @OA_create_err <> 0

begin

EXEC @OA_GetErrorInfo_err = sp_OAGetErrorInfo @WmiServiceLocator, @source...

If you scroll back a few pages in this thread, you will see that The Wizard Of Oz has posted a SQL 2000 version 🙂

@robert.sterbal 56890

Sure! The more the merrier 🙂

Also check out the graphical version using google graph and DBmail

http://www.sqlservercentral.com/articles/Jobs/127346/

@MiguelSQL

I left it intentionally, so you can use it as a basis for filtering 🙂

And again a new version based on some feedback by the community"

A multi day version of the script (1 timeline per 24 hours, stacked on top of each other)

Download link:...

Good idea, i'll tweak my script so it generates one graph per day if you specify a date range > 1 day.

Grtz,t

Bedankt Martijn 🙂

What do you mean, like averaging runtimes per job over a week/month?

Nice description of a not so obvious performance pitfall, i'm adding this gem to my list of things to scan for when debugging slow code. 🙂

Grtz,

Theo

Nice Article!

I'm defnitly trying this technique 🙂

Grtz,

Theo

Hi Guys,

A tip based on feedback of bmergen77, do *not* use apostrophs ' in JOB names, that breaks the script and you end up with an unrenderable HTML.

Grtz,

Theo