parallel proc calls

• Snargables

  SSCrazy Eights

  Points: 8855

  More actions

  February 21, 2013 at 2:30 pm

  #289899

  i have a stored proc that i pass a tablename into and then it has logic in it that will update n number of records in the given table.

  i want to build a script that will run n umber of proc calls at the same time and not sequentially. So, theoretically run the update across all the tables at the same time.

  anyone know of a way i can do that?

  So far the only way i can think of to do this is to dynamically create n number of jobs, each w/ asepearate proc call for a given table and have them scripted to start at the same time. Id rather not do that though.

• Anuj Rathi

  Say Hey Kid

  Points: 703

  More actions

  February 22, 2013 at 2:41 am

  #1590248

  you can also use CLR code & use multi threading to start several parallel process.