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 |
|
Tasta
Yak Posting Veteran
60 Posts |
 Posted - 2009-04-16 : 04:33:08
|
| Hi !I have a job that its steps have to run in a sequence - steps 2 and 3 simultaneously after step 1, and step 4 after steps 2 and 3 are finished. Is it possible to define ? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-16 : 11:29:45
|
| yup..its possible. you can return a status bit after 2,3rd step execution and execute 4 based on its value. |
 |
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-04-16 : 11:50:14
|
| Hi ! Where exactly can I define that 1. after step 1 will be running steps 2 and 3 at the same time 2. that step 4 must begin only when the longest of steps 2 and 3 is finished ? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-16 : 13:52:57
|
| you can use a procedure which integrates the 2 & 3rd steps inside it and has a return status bit. you make second step as excuting this procedure and third step involves checking this status bit and doing reqd processing |
|
|
|
|
|
|
Job with multiple steps