# Schedule Task for Export **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [October 1, 2020, 2:17pm UTC](https://forums.toadworld.com/t/schedule-task-for-export/51141 "2020-10-01T14:17:48Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![crashed](https://avatars.discourse-cdn.com/v4/letter/c/e56c9b/32.png) [@crashed](https://forums.toadworld.com/u/crashed)\ **Post date:** [October 1, 2020, 2:17pm UTC](https://forums.toadworld.com/t/schedule-task-for-export/51141/1 "2020-10-01T14:17:48Z")
Hey everyone, I set the computer's boot time on every morning at 08.00. At the same time i set toad to open with windows scheduled tasks. Can toad export the query I want when the computer is turned on automatically? Because my query export is too slow, I thought a solution like that ---
**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:** [October 1, 2020, 4:23pm UTC](https://forums.toadworld.com/t/schedule-task-for-export/51141/2 "2020-10-01T16:23:36Z")
Doesn't look you finished your entire ask here, but if I can extrapolate from what you did share... Sounds like you're scheduling an export via Toad, and the export may run long. There might be no need to "schedule" Toad to open, since you can invoke Toad via command line to execute an automation flow at any time, or schedule any automation jobs to run at scheduled times, via the Task Scheduler of course. In other words, you don't have to open Toad for the Windows-scheduled tasks to run. That said, I would be careful not to invoke Toad (either via Task Scheduler or via scheduled Toad Automation) too close after your workstation boots up... give enough time for your workstation to boot up cleanly, and then fire off the Windows-schedule tasks involving Toad... say, maybe 5 minutes after boot up. If I have misunderstood, then please relay extra details of what you're attempting to do ... ---
**Author:** ![crashed](https://avatars.discourse-cdn.com/v4/letter/c/e56c9b/32.png) [@crashed](https://forums.toadworld.com/u/crashed)\ **Post date:** [October 1, 2020, 8:59pm UTC](https://forums.toadworld.com/t/schedule-task-for-export/51141/3 "2020-10-01T20:59:39Z")
My goal is that I want my computer to be turned on before I come to the office and export to the my view to excel I use. So when I come to work, I want everything ready. That's why I talked about using Windows scheduled tasks. I am open to every suggestions. ---
**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:** [October 1, 2020, 10:00pm UTC](https://forums.toadworld.com/t/schedule-task-for-export/51141/4 "2020-10-01T22:00:05Z")
try this: > [@Scheduling for Dummies - Automation Designer](https://forums.toadworld.com/t/scheduling-for-dummies-automation-designer/34000/2): > > 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:** ![crashed](https://avatars.discourse-cdn.com/v4/letter/c/e56c9b/32.png) [@crashed](https://forums.toadworld.com/u/crashed)\ **Post date:** [October 2, 2020, 9:25am UTC](https://forums.toadworld.com/t/schedule-task-for-export/51141/5 "2020-10-02T09:25:22Z")
Automation designer and Task Scheduler are great features. Thanks for your support. Now i have a problem that i must use excel instance for export. because "excel file export" option fails. Schedule toad action wanting "authenticate user" and it does not allow to leave blank. if i set a password for login to windows for authenticate use , when the computer open by bios it is not coming to the desktop because of password, and i cant reach to the created file how can i fix that? ---
**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:** [October 2, 2020, 12:00pm UTC](https://forums.toadworld.com/t/schedule-task-for-export/51141/6 "2020-10-02T12:00:36Z")
If your company will allow, you could make your computer auto-login to windows, [https://support.microsoft.com/en-us/help/324737/how-to-turn-on-automatic-logon-in-windows](https://support.microsoft.com/en-us/help/324737/how-to-turn-on-automatic-logon-in-windows) ---
**Author:** ![russell.cannon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/russell.cannon/32/12042_2.png) [@russell.cannon](https://forums.toadworld.com/u/russell.cannon)\ **Post date:** [October 2, 2020, 10:38pm UTC](https://forums.toadworld.com/t/schedule-task-for-export/51141/7 "2020-10-02T22:38:28Z")
LOLs! I am not meaning to criticize, but that is a bad idea. While it is probably a technically viable solution for _crashed_, no computer--especially in shared workspaces--should be configured to auto-login on boot to Windows. Anyone could turn it on at any time and do stuff as that logged in user--stuff that could embarrass or cause trouble. I don't do that even for my own personal workstations in my own personal residence. Cheers, Russ ---
**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:** [October 3, 2020, 1:06am UTC](https://forums.toadworld.com/t/schedule-task-for-export/51141/8 "2020-10-03T01:06:05Z")
Yeah, OK, I admit. It's a bad idea. Maybe you could export to CSV and then open that in excel when you get in to work ---
**Author:** ![crashed](https://avatars.discourse-cdn.com/v4/letter/c/e56c9b/32.png) [@crashed](https://forums.toadworld.com/u/crashed)\ **Post date:** [October 4, 2020, 10:12am UTC](https://forums.toadworld.com/t/schedule-task-for-export/51141/9 "2020-10-04T10:12:20Z")
Thanks for all suggestions. I really get useful information from here. I especially appreciate the patience and quick feedbacks. Good work everyone 🙂 ---
**Author:** ![ISuiGenerisI](https://avatars.discourse-cdn.com/v4/letter/i/d9b06d/32.png) [@ISuiGenerisI](https://forums.toadworld.com/u/ISuiGenerisI)\ **Post date:** [January 2, 2023, 5:43pm UTC](https://forums.toadworld.com/t/schedule-task-for-export/51141/10 "2023-01-02T17:43:04Z")
crashed did you solve the problem with "authenticate user"? i have the same isue u.u