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

Get SQL job status for all servers. Expand / Collapse
Author
Message
Posted Sunday, September 23, 2007 7:06 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, April 11, 2014 12:29 PM
Points: 3,924, Visits: 1,586
Comments posted to this topic are about the item Get SQL job status for all servers.

SQL DBA.
Post #401787
Posted Thursday, September 04, 2008 3:20 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, April 12, 2014 12:17 AM
Points: 282, Visits: 2,208
You create the column Jmessage initially but don't pull over the message to populate it.

I'm playing with it now and modified this piece of code with the addition in bold.
--Change run duration into something you can recognize (hh:mm:ss)
, LEFT(RIGHT('000000' + CAST(run_duration AS VARCHAR(10)),6),2) + ':' +
SUBSTRING(RIGHT('000000' + CAST(run_duration AS VARCHAR(10)),6),3,2) + ':' +
RIGHT(RIGHT('000000' + CAST(run_duration AS VARCHAR(10)),6),2)
, sjh.message



MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
Post #564216
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse