|
I have a 2 SQL JOBs that I can see have been running for 2 days. How can I find out if there is any blocking or whats causing this ?
(comments are locked)
|
|
If you are using SQL server 2005 or later, then you can use sys.dm_os_waiting_tasks and sys.dm_tran_locks, se books online:
(comments are locked)
|
|
You can run this command I always start with EXEC sp_who2 Active. The results from here will help me figure out where I go next.
Nov 10 '09 at 11:29 AM
Alvin Ramard
(comments are locked)
|


Can you please add some more information. What are the jobs doing (index maintenance, executing stored procedure or what)? SQL server version? Like Peso answer, sp_who2 can give you a hint on what is happening.