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 |
|
noamg
Posting Yak Master
215 Posts |
 Posted - 2011-05-25 : 03:37:03
|
| Question:1. Each time the job start running, is it create a new connection to DB ?2. Is their any connection pool for jobs ?thanksNoam Graizer |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-05-25 : 03:45:05
|
| A job connection is like any other connection to sql server...it will use the same connection of the old one is available (sleeping). If not, it will create a new one.- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
|
|
|
job and connection