Thank this author by sharing:
By webtekkie, 2010/06/01
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!
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
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
