job execution

Greetings.

We generate table exports on a SQL Server 2005 instance at irregular intervals. Often when exports are required we have a number of them that need to be run. We've found that the exports job run sequentially. Is there a way of simultaneously executing the jobs ?

Thanks.

alan

If you are referring to several steps in a SQL Agent Job, then they always run sequentially. You could make a separate Job for each of the steps, and, depending upon your server hardware and the user activity, they may then run in parallel.

You could create a DTS (SQL 2000) or SSIS (SQL 2005) package, and in the package you could easily extablish that the various 'steps' were to run in parallel.

|||

Very helpful.

Thank you.