# Running multiple scripts in one shot

**URL:** <https://forums.toadworld.com/t/running-multiple-scripts-in-one-shot/39886>\
**Category:** Toad for SQL Server\
**Created:** [August 21, 2017, 12:05pm UTC](https://forums.toadworld.com/t/running-multiple-scripts-in-one-shot/39886 "2017-08-21T12:05:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![costabas](https://avatars.discourse-cdn.com/v4/letter/c/258eb7/32.png) [@costabas](https://forums.toadworld.com/u/costabas)\
**Post date:** [August 21, 2017, 12:05pm UTC](https://forums.toadworld.com/t/running-multiple-scripts-in-one-shot/39886/1 "2017-08-21T12:05:17Z")

</div>

Hi:

More often than not, I have multiple scripts that I need to run as part of a test/production deployment or during development. For instance, I have a script that creates tables and another one that populates them with data. Sometimes, I want to run both scripts in one shot. Currently, I have them open in two tabs, I select one script, I run it (I press F5), I wait until it’s done, then I select the other script and I run it. As a side note, In 6.8, when I run a script that takes longer to process, it blocks the entire UI - as far as I recall it didn’t used to do this in 6.7.

Anyway, in my mind it would be nice if Toad allowed me to define a deployment manifest consisting of the scripts I want to run so I can run them using one click. Is this currently doable in 6.8?

The alternative is to define a cmd file and use the sqlcmd utility to run the scripts. That’s what I’ve done so far.

Thanks

---

<div class="post-metadata">

**Author:** ![costabas](https://avatars.discourse-cdn.com/v4/letter/c/258eb7/32.png) [@costabas](https://forums.toadworld.com/u/costabas)\
**Post date:** [August 22, 2017, 10:10am UTC](https://forums.toadworld.com/t/running-multiple-scripts-in-one-shot/39886/2 "2017-08-22T10:10:31Z")

</div>

Ok, this is doable with the Automation Manager, where one drags and drops execution script tasks.

---

<div class="post-metadata">

**Author:** ![michael](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@michael](https://forums.toadworld.com/u/michael)\
**Post date:** [September 6, 2017, 10:38pm UTC](https://forums.toadworld.com/t/running-multiple-scripts-in-one-shot/39886/3 "2017-09-06T22:38:00Z")

</div>

good to hear that you have found solution for you

Michael