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

Show when all jobs were running Expand / Collapse
Author
Message
Posted Monday, October 1, 2007 6:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 24, 2004 3:54 AM
Points: 1, Visits: 1
Comments posted to this topic are about the item Show when all jobs were running
Post #404973
Posted Wednesday, December 26, 2007 12:58 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 1:41 PM
Points: 110, Visits: 497
Sweet Script.

I used this today to help troubleshoot some production issues.

I cleaned the script up a bit in the following ways:

1. included a "USE MSDB" statement at top because I kept running it in the application DB and kept getting the sysjobs does not exist error
2. Made the date automatically go to Yesterday so I didnt have to type in a new date if I dont want to
3. set a If Exists() statement before the DROP # table statement at the end
4. Set my granularity to 60 seconds so I can see what jobs are running every minute of every day as most jobs complete within a minute or two.

thanks, quite helpful

Greg Jackson
Portland, OR


Gregory A Jackson MBA, CSM
Post #436476
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse