|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hi all,
Is there any way so that we can run/ execute multiple jobs or local packeges at once. Can we create any sql script which will execute multiple jobs/packeges at once. please advise ![]() |
|
#2
|
||||
|
||||
|
Do you mean parallel execution? Or launching one package that launches many others?
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) |
|
#3
|
|||
|
|||
|
Quote:
Thanks for the quick response... It will be great if you could provide both ways of execxution. I can try btoth of them. But my requirement suits the later one ( launching one package that launches many others). Thank you... |
|
#4
|
||||
|
||||
|
Just look more carefully to DTS package building GUI, there is a specific task, named Execute Package Task.
|
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Executing multiple Jobs / Local Packeges at once |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|