Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Job History with Timeline

By webtekkie,

Have you ever had a problem which you suspect was caused by two jobs running simultaneously? This script will give you a visual representation of the period that jobs were running over. It uses the REPLICATE function to produce a series of spaces (which represents the period before the job ran) and X's (to represent the period the job was running.

 

Enjoy!

Total article views: 2903 | Views in the last 30 days: 17
 
Related Articles
FORUM

How to insert missing periods ?

Adding missing periods to data set

FORUM

Count Months (periods) on program

Need to counts periods and spells on a program

FORUM

Lock request time our period exceeded

Lock request time our period exceeded

FORUM

Matching Date periods to specific date

match a period to multiple dates

FORUM

Lock Request time out period exceeded

Lock Request time out period exceeded

Tags
history    
jobs    
sql agent    
timeline    
 
Contribute