KirbyWallace
Programmer
When multiple jobs are scheduled to begin at the same time, how does the Agent handle this? Does it attempt to run all sequentially in a single thread? Or does it multi-thread and run the jobs simultaneously?
Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Agent - Stacking Jobs 1
- Thread starter KirbyWallace
- Start date
- Status
When multiple jobs are scheduled to begin at the same time, how does the Agent handle this? Does it attempt to run all sequentially in a single thread? Or does it multi-thread and run the jobs simultaneously?
Thanks!
-
1
- #2
mrdenny
Programmer
- May 27, 2002
- 11,595
Each job is run in a separate thread in parallel.
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
My Blog
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
My Blog
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
