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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Job execution in a batch

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-05-17 : 17:52:03
I need to execute around 100 SQL server jobs in a batch. If I execute them in a batch will they get executed linearly or asynchronously?


------------------------
I think, therefore I am - Rene Descartes

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-05-17 : 19:31:12
if you launch them by calling msdb.dbo.sp_start_job many times in succession, they will be asynchronous because sp_start_job returns immediately.


www.elsasoft.org
Go to Top of Page
   

- Advertisement -