asked
Parallel Procedures by Trans-SQL
Hi, I need to made a process that need to made 3 part of it working in parallel. Well I don't know how made it using trans-SQL. I add a diagram about it:![alt text][1] Thanks for your time, [1]: /storage/temp/4312-diagrama.png
Doing this in straight T-SQL is tricky, as generally a single SQL Server script / procedure is executed one statement at a time in serial, and there's no real concept of that sort of flow control. Having said that, you do have a couple of options in the SQL Server world: 1. use SSIS (SQL Server integration Services) - this contains the control structures to allow you to build your desired flow 2. If you want to keep it in T-SQL, then you could use the SQL Server agent and set up a series of jobs. Here you would have three jobs for Processes 1, 2, 3, and these would be controlled by a separate job that does the pre-processing, kicks off the three other jobs using msdb.dbo.sp_start_job, and then sits in a loop periodically checking for those jobs to complete before doing the final step.
Interesting that these are 2 approaches you are trying to avoid. Why are you trying to avoid these?
17 People are following this question.
