Show when all jobs were running

  • Stephen Leach

    Grasshopper

    Points: 21

    Comments posted to this topic are about the item Show when all jobs were running

  • GregoryAJackson

    SSCrazy

    Points: 2794

    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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply