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)
 sql job

Author  Topic 

kumarich1
Yak Posting Veteran

99 Posts

Posted - 2008-10-24 : 11:18:17
I have a job which has multiple steps in it, each step runs one after the other,
but I want some steps in it to run simultaneously instead of waiting for other one to complete.Please advise how can I do this.

Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-24 : 12:13:43
Can you explain about steps in jobs?
Go to Top of Page

kumarich1
Yak Posting Veteran

99 Posts

Posted - 2008-10-24 : 12:23:52
quote:
Originally posted by sodeep

Can you explain about steps in jobs?



each step executes one procedure, I want to run these steps all at once instead of one by one.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-24 : 12:25:27
Are those SPs related ?
Go to Top of Page

kumarich1
Yak Posting Veteran

99 Posts

Posted - 2008-10-24 : 12:30:51
quote:
Originally posted by sodeep

Are those SPs related ?



They are not related ,they can be run independently, I think I can put all the procedures in one step so they all run at one time.
Go to Top of Page
   

- Advertisement -