Show when all jobs were running

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 Stephen Leach » Show when all jobs were running

Show when all jobs were running

Rate Topic

Display Mode

Topic Options

Author

Message

Stephen Leach

Posted Monday, October 01, 2007 6:45 AM

Forum 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

GregoryAJackson

Posted Wednesday, December 26, 2007 12:58 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 26, 2013 2:11 PM
Points: 108, Visits: 485

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 »

Permissions