# automation

**URL:** <https://forums.toadworld.com/t/automation/28950>\
**Category:** Toad for IBM DB2\
**Created:** [February 25, 2014, 11:59am UTC](https://forums.toadworld.com/t/automation/28950 "2014-02-25T11:59:56Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![andrew.bonniwell](https://avatars.discourse-cdn.com/v4/letter/a/258eb7/32.png) [@andrew.bonniwell](https://forums.toadworld.com/u/andrew.bonniwell)\
**Post date:** [February 25, 2014, 11:59am UTC](https://forums.toadworld.com/t/automation/28950/1 "2014-02-25T11:59:56Z")

</div>

I have set up some queries to run and export exceptions list periodically (monthly, weekly, daily, etc.) I have set up the exports to do exactly as I want except for the naming convention. Is there a way to name each file with some text and then the date that the report was run? Thanks for your assistance!

---

<div class="post-metadata">

**Author:** ![Jeff\_Podlasek](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jeff_podlasek/32/29_2.png) [@Jeff\_Podlasek](https://forums.toadworld.com/u/Jeff_Podlasek)\
**Post date:** [February 26, 2014, 2:44pm UTC](https://forums.toadworld.com/t/automation/28950/2 "2014-02-26T14:44:40Z")

</div>

You can use our automation feature (Tools | Automation) to set up an automation script that uses an export wizard that saves the results of a query (or exports a table) to an output file.

That file can be many formats including excel and can have the date/time included as part of the file name.

 ![ExportAuto.jpeg](https://global.discourse-cdn.com/quest/original/2X/c/ced30491c8829a028f32235e4062b48d8b664fa3.jpeg)

You can run these automation scripts manually or schedule then to be executed via the windows scheduler whenever you wish.

---

<div class="post-metadata">

**Author:** ![andrew.bonniwell](https://avatars.discourse-cdn.com/v4/letter/a/258eb7/32.png) [@andrew.bonniwell](https://forums.toadworld.com/u/andrew.bonniwell)\
**Post date:** [February 27, 2014, 5:54am UTC](https://forums.toadworld.com/t/automation/28950/3 "2014-02-27T05:54:33Z")

</div>

Thank you so much… I feel like an idiot for not seeing that button!

---

<div class="post-metadata">

**Author:** ![Shimonj](https://avatars.discourse-cdn.com/v4/letter/s/54ee81/32.png) [@Shimonj](https://forums.toadworld.com/u/Shimonj)\
**Post date:** [February 8, 2016, 7:49am UTC](https://forums.toadworld.com/t/automation/28950/4 "2016-02-08T07:49:31Z")

</div>

Hi,

I run updates and various schemas and want to see the results of each statement. Is there any simple way to save the results in a file?

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [February 8, 2016, 10:27am UTC](https://forums.toadworld.com/t/automation/28950/5 "2016-02-08T10:27:11Z")

</div>

I have a lot of videos for automation that I have made for Toad Data Point. These will apply to Toad for DB2.

[dev.toadforsqlserver.com/…/TDPVideo.html](http://dev.toadforsqlserver.com/TDPVideos/TDPVideo.html#tab3)

Have a look. I think these will bring you up to speed very quickly.

---

<div class="post-metadata">

**Author:** ![Shimonj](https://avatars.discourse-cdn.com/v4/letter/s/54ee81/32.png) [@Shimonj](https://forums.toadworld.com/u/Shimonj)\
**Post date:** [September 4, 2018, 9:24am UTC](https://forums.toadworld.com/t/automation/28950/6 "2018-09-04T09:24:58Z")

</div>

Hi Debbie,  
I watched some of them and they are indeed eye-openers.  
Thank alot,  
Shimon J.