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 |
|
kote_alex
Posting Yak Master
112 Posts |
 Posted - 2010-03-17 : 06:39:16
|
| what stored procedure limits the max_work_thread for sql agent jobs ?thanks ! |
|
|
kote_alex
Posting Yak Master
112 Posts |
Posted - 2010-03-17 : 11:27:25
|
| anyone? |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-17 : 11:57:11
|
| there isn't one as far as i know. but take a look at sp_enum_sqlagent_subsystems and the syssubsystems table.also might want to execute sp_helptext 'sp_enum_sqlagent_subsystems_internal' and look at the output |
|
|
|
|
|
|
limit simultaneous jobs repl