Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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)

Email Long Running SPID Info

By Deon Benjamin,

This script will check for long running SPIDS and mail the SPID number, duration,
username and the SQL being executed.

It can be run ad-hoc or run as a scheduled job, or you could make a stored procedure out of it.
It reports on the longest running SPID in the instance with an execution time greater than 2 minutes
It will email an HTML formatted table.

The script uses a table called master.dbo.LongRunningQueries, but you can use a
temp table or put this table wherever you want.

This has been tested on SQL 2008 R2 but should work on any version of 2008, and probably 2005 as well.

As it stands it can be pasted into a query window or job and run.

Total article views: 2093 | Views in the last 30 days: 11

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

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

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones