# Scheduling tasks on server vs local - TOAD for Data Analyst 3.1

**URL:** <https://forums.toadworld.com/t/scheduling-tasks-on-server-vs-local-toad-for-data-analyst-3-1/7597>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [February 19, 2013, 3:26pm UTC](https://forums.toadworld.com/t/scheduling-tasks-on-server-vs-local-toad-for-data-analyst-3-1/7597 "2013-02-19T15:26:04Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![jennifer.mccolley201](https://avatars.discourse-cdn.com/v4/letter/j/22d042/32.png) [@jennifer.mccolley201](https://forums.toadworld.com/u/jennifer.mccolley201)\
**Post date:** [February 19, 2013, 3:26pm UTC](https://forums.toadworld.com/t/scheduling-tasks-on-server-vs-local-toad-for-data-analyst-3-1/7597/1 "2013-02-19T15:26:04Z")

</div>

It seems that you can only schedule tasks to run locally on your Windows machine, so that you can’t really share the maintenance of scheduled tasks with other people and your machine has to be on. What is involved in setting up TOAD for Data Analysts to be able to schedule tasks on a server? I couldn’t find any documentation on this anywhere. Thanks.

---

<div class="post-metadata">

**Author:** ![itlnstln](https://avatars.discourse-cdn.com/v4/letter/i/73ab20/32.png) [@itlnstln](https://forums.toadworld.com/u/itlnstln)\
**Post date:** [February 20, 2013, 7:21am UTC](https://forums.toadworld.com/t/scheduling-tasks-on-server-vs-local-toad-for-data-analyst-3-1/7597/2 "2013-02-20T07:21:41Z")

</div>

I would imagine you would have to set up Toad on a server and have users RDP to that server and set up/run their jobs from there.

I don’t do reporting out of TDP (I do more web development and ETL), so for “simple” SQL-only tasks, I use command-line tools like BTEQ (Teradata) and SQL+ (Oracle) and schedule them with Windows Task Scheduler on a server.

I don’t know if that helps.

---

<div class="post-metadata">

**Author:** ![N.B](https://avatars.discourse-cdn.com/v4/letter/n/bc8723/32.png) [@N.B](https://forums.toadworld.com/u/N.B)\
**Post date:** [February 21, 2013, 10:24am UTC](https://forums.toadworld.com/t/scheduling-tasks-on-server-vs-local-toad-for-data-analyst-3-1/7597/3 "2013-02-21T10:24:50Z")

</div>

That's what we're doing in my office. I made the suggestion some time ago that they should develop a server type executable to handle multiple users creating scheduled automations, but nothing seems to have come of it.

> I would imagine you would have to set up Toad on a  
> server and have users RDP to that server and set  
> up/run their jobs from there.

---

<div class="post-metadata">

**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\
**Post date:** [February 21, 2013, 10:59am UTC](https://forums.toadworld.com/t/scheduling-tasks-on-server-vs-local-toad-for-data-analyst-3-1/7597/4 "2013-02-21T10:59:57Z")

</div>

I created the CR 106914 to track the enhancement.

Aleksey

---

<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:** [March 7, 2013, 2:24pm UTC](https://forums.toadworld.com/t/scheduling-tasks-on-server-vs-local-toad-for-data-analyst-3-1/7597/5 "2013-03-07T14:24:24Z")

</div>

The solution to this issues is scheduled for the next major release. Stay posted:)

Debbie

---

<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:** [March 7, 2013, 2:24pm UTC](https://forums.toadworld.com/t/scheduling-tasks-on-server-vs-local-toad-for-data-analyst-3-1/7597/6 "2013-03-07T14:24:45Z")

</div>

Meaning TDP 3.5.

---

<div class="post-metadata">

**Author:** ![GregDavis11009](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gregdavis11009/32/122_2.png) [@GregDavis11009](https://forums.toadworld.com/u/GregDavis11009)\
**Post date:** [March 12, 2013, 3:19pm UTC](https://forums.toadworld.com/t/scheduling-tasks-on-server-vs-local-toad-for-data-analyst-3-1/7597/7 "2013-03-12T15:19:22Z")

</div>

I have Toad 3.1 installed on a server and it works great. We remote in to the server and schedule the jobs there. We also had our IT set up special connections with passwords that never expire. The problem we ran into was that any import or export steps had to be recreated because they store the original users connection information in them.

I can’ t wait try 3.5!

- Greg
