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 |
|
slimt_slimt
Aged Yak Warrior
746 Posts |
 Posted - 2009-09-21 : 15:40:26
|
| hi,i would like to track all jobs running (from start point to end point with all steps) in SQL job agent and to track which is running simultaneously and if one of the jobs is making a lock on table, which affects another job.thank you for your help.best |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-09-21 : 16:28:21
|
| Have you looked at any of the following yet?"Job Activity Monitor" (under Sql Server Agent of Object Explorer)"Activity Monitor" (under Management of Object Explorer) "Standard Reports" (from right-clicking objects in Object Explorer)Be One with the OptimizerTG |
 |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2009-09-21 : 16:37:20
|
| Yes, i've looked at this. i was thinking more like o write sql for jobs coinciding with each other.or is this also possible here. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2009-09-28 : 15:39:47
|
| thank you for url link. |
|
|
|
|
|
|
jobs in job agent - sql 2000/2005