Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

SQL Job Timeline (Graphical) Expand / Collapse
Author
Message
Posted Monday, January 28, 2013 10:10 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 21, 2014 3:10 PM
Points: 32, Visits: 497
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
Posted Tuesday, January 29, 2013 4:52 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, November 22, 2014 7:25 AM
Points: 338, Visits: 1,438
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
Posted Tuesday, January 29, 2013 7:10 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, November 24, 2014 8:33 AM
Points: 535, Visits: 888
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 12yrs in IT and 10yrs happily stuck with SQL.

http://aseniuk.wordpress.com
- SQL 2008/R2/2012/2014
- Oracle 8/9/10/11
- MySQL 4/5
Post #1413031
Posted Tuesday, January 29, 2013 7:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 27, 2014 6:44 AM
Points: 9, Visits: 540
I get the error in SQL 2005, 08 and 08R2
Post #1413034
Posted Tuesday, January 29, 2013 7:32 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 7:07 AM
Points: 106, Visits: 950
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
Posted Tuesday, January 29, 2013 7:40 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, November 24, 2014 8:33 AM
Points: 535, Visits: 888
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 12yrs in IT and 10yrs happily stuck with SQL.

http://aseniuk.wordpress.com
- SQL 2008/R2/2012/2014
- Oracle 8/9/10/11
- MySQL 4/5
Post #1413052
Posted Tuesday, January 29, 2013 7:44 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, November 24, 2014 8:33 AM
Points: 535, Visits: 888
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 12yrs in IT and 10yrs happily stuck with SQL.

http://aseniuk.wordpress.com
- SQL 2008/R2/2012/2014
- Oracle 8/9/10/11
- MySQL 4/5
Post #1413055
Posted Tuesday, January 29, 2013 8:45 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 21, 2014 3:10 PM
Points: 32, Visits: 497
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
Posted Tuesday, January 29, 2013 9:16 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:38 AM
Points: 27, Visits: 508
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
Posted Tuesday, January 29, 2013 9:34 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 7:07 AM
Points: 106, Visits: 950
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 »

Add to briefcase 123»»»

Permissions Expand / Collapse