SQL Job Timeline (Graphical)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Theo Ekelmans » SQL Job Timeline (Graphical)

23 posts, Page 1 of 3

1 2 3 »»»

SQL Job Timeline (Graphical)

Rate Topic

Display Mode

Topic Options

Author

Message

Theo Ekelmans

Posted Monday, January 28, 2013 10:10 PM

Grasshopper

Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 17, Visits: 303

Comments posted to this topic are about the item <A HREF="/scripts/Job/96230/">SQL Job Timeline (Graphical)</A>

Thanks for the feedback, and yes.... My bad, i left ONE line of code in that is SQL 2012 specific, if you comment out line 77, the code will work in 2005 (i tested it with build 4053).

--,CAST(STUFF(STUFF(REPLACE(STR(run_duration, 6), ' ', '0'), 3, 0, ':'), 6, 0, ':') AS time(0)) AS Duration

Alternate download location for people having issues with Internet explorer downloading:

https://dl.dropbox.com/u/43939704/MS_SQL_JOB_timeline.xlsx

Theo :)

Post #1412750

Jonathan AC Roberts

Posted Tuesday, January 29, 2013 4:52 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 6:40 AM
Points: 322, Visits: 1,221

Just tried running it on SQL Server 2005 and got this error:

Msg 1001, Level 15, State 1, Line 77
Line 77: Length or precision specification 0 is invalid.

With this line highlighted:
,CAST(STUFF(STUFF(REPLACE(STR(run_duration, 6), ' ', '0'), 3, 0, ':'), 6, 0, ':') AS time(0)) AS Duration

It doesn't like "time(0)"

Post #1412928

Adam Seniuk

Posted Tuesday, January 29, 2013 7:10 AM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 12:13 PM
Points: 478, Visits: 732

This ran fine on SQL 2008 and SQL 2008 R2.

This would be a great report to run on systems with a few parameters like date range and increment amount (aka Resolution)

Great job, always like seeing what my jobs are doing.

Thanks

Over 11yrs in IT and 9yrs happily stuck with SQL.

http://aseniuk.wordpress.com
- SQL 2008/R2/2012
- Oracle 8/9/10
- MySQL 4/5

Post #1413031

Derek Wharton

Posted Tuesday, January 29, 2013 7:14 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 04, 2013 11:36 AM
Points: 9, Visits: 464

I get the error in SQL 2005, 08 and 08R2

Post #1413034

Lee Linares

Posted Tuesday, January 29, 2013 7:32 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 7:54 AM
Points: 71, Visits: 603

Thanks for taking the time and effort to share this script with us. I downloaded the file from your link for the sample Excel file but the zip file that was downloaded did not contain any Excel file. Did I misunderstand something? Thanks again.

Lee

Post #1413045

Adam Seniuk

Posted Tuesday, January 29, 2013 7:40 AM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 12:13 PM
Points: 478, Visits: 732

Command(s) completed successfully. - I ran this on 10.50.4263, 10.50.2500, 10.50.4000 and 10.0.5826 with no issues...

What versions are you running we may have a fix applied in the most upto date version that is allowing it to work.

Over 11yrs in IT and 9yrs happily stuck with SQL.

http://aseniuk.wordpress.com
- SQL 2008/R2/2012
- Oracle 8/9/10
- MySQL 4/5

Post #1413052

Adam Seniuk

Posted Tuesday, January 29, 2013 7:44 AM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 12:13 PM
Points: 478, Visits: 732

My oldest version 2005 9.0.1399 gives me this error

Msg 1001, Level 15, State 1, Line 77
Line 77: Length or precision specification 0 is invalid.

Over 11yrs in IT and 9yrs happily stuck with SQL.

http://aseniuk.wordpress.com
- SQL 2008/R2/2012
- Oracle 8/9/10
- MySQL 4/5

Post #1413055

Theo Ekelmans

Posted Tuesday, January 29, 2013 8:45 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 17, Visits: 303

Hi Guys,

Thanks for the feedback, and yes.... My bad, i left ONE line of code in that is SQL 2012 specific, if you comment out line 77, the code will work in 2005 (i tested it with build 4053).

--,CAST(STUFF(STUFF(REPLACE(STR(run_duration, 6), ' ', '0'), 3, 0, ':'), 6, 0, ':') AS time(0)) AS Duration

@Lee Linares: The link points to a EXCEL 2010 sheet, not a zip file.

@Adam Seniuk: you can set the resolution here (down to 1 minute) : set @Resolution = 1 -- Enter the Resolution in minutes

Theo :)

Post #1413095

Phil-94129

Posted Tuesday, January 29, 2013 9:16 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 04, 2013 1:14 PM
Points: 27, Visits: 374

What format is the "Excel" worksheet in - I downloaded a .zip file, with a series of .xml files - no xls or .xlsx files.

Post #1413130

Lee Linares

Posted Tuesday, January 29, 2013 9:34 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 7:54 AM
Points: 71, Visits: 603

I also had the same problem as Phil-94129 but after communicating with Theo (thanks Theo) and trying several suggestions I found that I only had this download problem using Internet Explorer. I had a team mate try it with FireFox and the download as an Excel file worked perfectly.

Lee

Post #1413146

« Prev Topic | Next Topic »

23 posts, Page 1 of 3

1 2 3 »»»

Permissions