• well I don't wish to appear negative but checking for a lock that has been held for 5 to 10 mins might not be very efficient. I do a similar check periodically on our oltp systems but I check every 5 seconds for blocking locks.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/