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)
Thank this author by sharing:
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.
Adding missing periods to data set
Need to counts periods and spells on a program
Lock request time our period exceeded
match a period to multiple dates
Lock Request time out period exceeded