# Scheduling for Dummies - Automation Designer **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [August 28, 2015, 6:34am UTC](https://forums.toadworld.com/t/scheduling-for-dummies-automation-designer/34000 "2015-08-28T06:34:27Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![USSteresa](https://avatars.discourse-cdn.com/v4/letter/u/c0e974/32.png) [@USSteresa](https://forums.toadworld.com/u/USSteresa)\ **Post date:** [August 28, 2015, 6:34am UTC](https://forums.toadworld.com/t/scheduling-for-dummies-automation-designer/34000/1 "2015-08-28T06:34:27Z")
I am an analyst who uses TOAD daily to run queries that have been written for me. I don’t know sql other than to make small tweaks here and there to existing scripts. BUT, I think if someone showed me the exact steps to schedule these queries to run on their own – I could follow the steps and set these up to run and export as excel - save tons of time. I watched a youtube video that I thought was going to show me how, but it seemed to be more focused on the WHAT can be done, but not the HOW. I have automation design open. I guess I’m going to list actions ie: Execute Script 1 under that I will put Export Data Set? Where do I copy and paste the script? Then what? If I wait for our systems team to do this it will take years. Any help is appreciated and remember, I’m not a DB ☹ ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [August 28, 2015, 6:46am UTC](https://forums.toadworld.com/t/scheduling-for-dummies-automation-designer/34000/2 "2015-08-28T06:46:03Z")
Drop an Export Dataset action in the automation designer (no Execute script action is needed for this). Double-click it and the query (without the ending semicolon) on the dataset tab. Then you can go back to the options tab to set up the export format. Then you can rt-click the action to run it or schedule it. If your scripts consist of multiple select statements, then you’ll have to repeat this process for each select statement. So, just one statement per Export Dataset action. ---
**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\ **Post date:** [August 28, 2015, 6:48am UTC](https://forums.toadworld.com/t/scheduling-for-dummies-automation-designer/34000/3 "2015-08-28T06:48:39Z")
If you’re just looking to get the output of a query, you can do it in one action in the automation designer. · Connect to your DB · Create an Export Dataset action · Select your Options (Excel, delimited text, file, …) · Select the Dataset tab · Paste your query · Test to make sure it works · Once you’re happy with it, right click on the Action and select Schedule. Of course, you can get very fancy with Actions by using folder iterators, scripts, e-mail, ftp, … Take a look at the samples that ship with Toad for examples of the power available to you. Hope that helps, Greg **From:** USSteresa [[mailto:bounce-USSteresa@toadworld.com](mailto:bounce-USSteresa@toadworld.com)] **Sent:** Friday, August 28, 2015 9:35 AM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** [Toad for Oracle - Discussion Forum] Scheduling for Dummies - Automation Designer **[Scheduling for Dummies - Automation Designer](http://www.toadworld.com/products/toad-for-oracle/f/10/t/25316)** Thread created by USSteresa I am an analyst who uses TOAD daily to run queries that have been written for me. I don’t know sql other than to make small tweaks here and there to existing scripts. BUT, I think if someone showed me the exact steps to schedule these queries to run on their own – I could follow the steps and set these up to run and export as excel - save tons of time. I watched a youtube video that I thought was going to show me how, but it seemed to be more focused on the WHAT can be done, but not the HOW. I have automation design open. I guess I’m going to list actions ie: Execute Script 1 under that I will put Export Data Set? Where do I copy and paste the script? Then what? If I wait for our systems team to do this it will take years. Any help is appreciated and remember, I’m not a DB ☹ To reply, please reply-all to this email. [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/25316?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10?subscribe=false) notifications altogether. Toad for Oracle - Discussion Forum [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/t/25316?AbuseContentId=853dd49c-d595-47f2-987a-b27f6c7ebc6e&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true) this post as spam/abuse.