# Scheduled Task in Automation **URL:** \ **Category:** Toad for SQL Server\ **Created:** [May 14, 2021, 7:18pm UTC](https://forums.toadworld.com/t/scheduled-task-in-automation/52791 "2021-05-14T19:18:55Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![susja](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@susja](https://forums.toadworld.com/u/susja)\ **Post date:** [May 14, 2021, 7:18pm UTC](https://forums.toadworld.com/t/scheduled-task-in-automation/52791/1 "2021-05-14T19:18:55Z")
Recently I found out that Toad has nice option 'Automation'. I tried to use it (just to test) and it works perfectly fine for me. For my curiosity I wanted to Schedule the Task but failed. What I did: ![Capture](https://global.discourse-cdn.com/quest/original/2X/c/c2a8784b9aaf12e99b3d8b0a993e55342394fbcb.png) 1. Login as domain\user 2. Connect to server 3. Create a simple Task and successfully executed it 4. Click on 'Schedule' button in 'Automation Script' dialog and took 'default' Schedule 5. It requested my credentials 6. When I click on 'Apply' it throws the error ( see attachment0 What could be the issue? Thanks ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [May 17, 2021, 4:56pm UTC](https://forums.toadworld.com/t/scheduled-task-in-automation/52791/2 "2021-05-17T16:56:00Z")
You haven't detailed the steps you are taking to create/schedule your "job", so rather then guess, I'll say that it's best to let Toad schedule the automation job for you. When you've tested your automation flow sufficiently, hit the "Schedule Automation" tool button above your workflow. Toad will ask you to name your job (\*.TAS file type) and then ask for details on how the task scheduler should initiate your job, per screen snap below... note that it picks up your Windows credentials automatically. ![image](https://global.discourse-cdn.com/quest/original/2X/c/c7f670c2442e82795539060eeadf0299eccf8b0f.png) ---
**Author:** ![susja](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@susja](https://forums.toadworld.com/u/susja)\ **Post date:** [May 18, 2021, 1:57am UTC](https://forums.toadworld.com/t/scheduled-task-in-automation/52791/3 "2021-05-18T01:57:48Z")
Hi Gary, You answers is always very valuable. Here are my steps just to validate that Scheduling works for me. 1. login 2. in 'Database Activities' select 'Execute Script' 3. 'Preview SQL' and populate statement: select TABLE\_NAME FROM INFORMATION\_SCHEMA.TABLES 4. 'Save Automation Script to file and add to Project' 5. It saved it at C:\Users\\AppData\Local\Quest Software\Toad for SQL Server 5.8\Toad Projects\test01.tas 6. Validated that it generates expected Result Set of 1092 rows 7. I click on 'Schedule' button but it didn't ask me to name the Job. It simply pop-up a dialog ( see attachment 1-3.png) 8. I click on OK button 9. In Job Manager I see the following ( attachment 4.png) 10. It has Status 'Not scheduled' 11. I do 'right-click' and 'Edit Task' and see the same as before i.e. attachments 1-3.png At which point I'm doing wrong? Thanks P.S. I see that your screenshot looks like regular Windows Task Scheduler but mine is completely different. Likely this is the culprit .. When I click on 'Schedule ..' it opens ![4](https://global.discourse-cdn.com/quest/original/2X/f/fbbc44cf36bed1010f16fb3d388c125e8ea00eab.png) ![3](https://global.discourse-cdn.com/quest/original/2X/9/9662334da4925a981763ee3419f20f1f7fe517e1.png) ![2](https://global.discourse-cdn.com/quest/original/2X/2/23ef4c5e6f531c9a3d2ef9cc9ec2f0a5c266358b.png) ![1](https://global.discourse-cdn.com/quest/original/2X/6/6023b31d4e1bd4486258f052cb92abcc7b1bbdef.png) dialog and ask me to save it ... and so on .. ---
**Author:** ![susja](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@susja](https://forums.toadworld.com/u/susja)\ **Post date:** [May 25, 2021, 2:43am UTC](https://forums.toadworld.com/t/scheduled-task-in-automation/52791/4 "2021-05-25T02:43:44Z")
- Gary, Any suggestions? Thanks ---
**Author:** ![susja](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@susja](https://forums.toadworld.com/u/susja)\ **Post date:** [June 5, 2022, 4:38pm UTC](https://forums.toadworld.com/t/scheduled-task-in-automation/52791/5 "2022-06-05T16:38:15Z")
Actually I wasn't able to fix the issue ... but I found the workaround : I started to use Windows Scheduled Tasks utility. Well .. likely it was not designed that way ... but at least I'm not blocked now.