Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
avmreddy17
Posting Yak Master
180 Posts |
 Posted - 2008-01-02 : 10:02:45
|
| Is it possible to set up a Job to send a notification , if a process is blocked for more than a minute on SQL Server 2000.Thanks for any help on this |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-02 : 11:22:13
|
| See if this helps:-[url]http://support.microsoft.com/kb/271509[/url] |
 |
|
|
sqlsquirrel
Starting Member
21 Posts |
Posted - 2008-01-02 : 13:23:43
|
| I have a SQL Server Agent job that runs every minute and executes a stored procedure that queries sysprocesses. If blocking is occurring for more than a set interval then the stored procedure will do a send mail and email the DBAs with the blocking information. This has been very effective in responding to block on a production SQL Server.Brett DavisSenior SQL Server DBAFor more helpful tips checkout my blog at: http://www.lockergnome.com/sqlsquirrel/ |
|
|
|
avmreddy17
Posting Yak Master
180 Posts |
Posted - 2008-01-02 : 22:25:49
|
| Can you please share the Stored Procs.Thanks Again |
|
|
|
|
|
|
Notification