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: Today @ 8:57 AM
Points: 28, Visits: 451
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: Wednesday, July 23, 2014 3:19 AM
Points: 338, Visits: 1,421
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, July 21, 2014 8:06 AM
Points: 533, Visits: 857
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
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: Friday, July 25, 2014 8:10 AM
Points: 9, Visits: 528
I get the error in SQL 2005, 08 and 08R2
Post #1413034
Posted Tuesday, January 29, 2013 7:32 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 17, 2014 1:24 PM
Points: 89, Visits: 875
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, July 21, 2014 8:06 AM
Points: 533, Visits: 857
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
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, July 21, 2014 8:06 AM
Points: 533, Visits: 857
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
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: Today @ 8:57 AM
Points: 28, Visits: 451
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: Yesterday @ 9:55 AM
Points: 27, Visits: 473
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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 17, 2014 1:24 PM
Points: 89, Visits: 875
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