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 |
|
cottage125
Starting Member
32 Posts |
 Posted - 2008-07-17 : 14:27:16
|
| Hi I have very basic and general question. SQL 2005 agent job is scheduled to run automatically and it uses lot of SPs under certain accountThere should be only one SPID for that job right? Or that job can issue multiple SPIds?? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-17 : 15:39:17
|
| Did you check it? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-17 : 23:36:15
|
| It should have only one spid. |
|
|
|
|
|
|
sql job spid