# Automation **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [March 8, 2016, 11:10am UTC](https://forums.toadworld.com/t/automation/35235 "2016-03-08T11:10:00Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![paul.stan](https://avatars.discourse-cdn.com/v4/letter/p/90ced4/32.png) [@paul.stan](https://forums.toadworld.com/u/paul.stan)\ **Post date:** [March 8, 2016, 11:10am UTC](https://forums.toadworld.com/t/automation/35235/1 "2016-03-08T11:10:00Z")
I have 4 automation scripts which run every night and feed 4 excel files. Yesterday I decided to organive the scripts into folders (one folder for each .tsm and .tas grouping) so that they would be easier to find (Still on the same drive in the same master folder), and I kept the excel files in their same locations. I also made sure to repoint the links in all of the automation scripts to the TSM files. When I look at Job Manager, it says that all 4 ran last night, but the Excel files haven’t updated. These tasks have been running just fine up until today, so I feel pretty sure that the reorganization is what caused this issue. How do I fix it? ---
**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\ **Post date:** [March 8, 2016, 11:55am UTC](https://forums.toadworld.com/t/automation/35235/2 "2016-03-08T11:55:26Z")
Hi, How do you execute the scripts? Do you use TIC Scheduler and execute the scripts on TIC server or execute them locally using Windows Task Scheduler? Could you run a script manually and send us the log file? Regards Aleksey ---
**Author:** ![paul.stan](https://avatars.discourse-cdn.com/v4/letter/p/90ced4/32.png) [@paul.stan](https://forums.toadworld.com/u/paul.stan)\ **Post date:** [March 8, 2016, 12:40pm UTC](https://forums.toadworld.com/t/automation/35235/3 "2016-03-08T12:40:16Z")
I use the scheduler built into toad. It worked perfectly when I ran it just now. This what the Job Manager looks like: And these are the files that are supposed to load. StaffID’s is the one I just ran. ClientRun.tas feeds ClientDemos ProdExport.tas feeds ProductivityRaw and AutoToadBill.tas feeds WelligentCurrentFY ActivePaysource.tas is set to only run on Mondays and Wednesdays. ---
**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\ **Post date:** [March 8, 2016, 1:32pm UTC](https://forums.toadworld.com/t/automation/35235/4 "2016-03-08T13:32:49Z")
Hi, Could you clarify couple questions? Have you run the scripts manually directly from Toad without scheduling them? Were the scripts executed successfully and populated Excel files? Regards Aleksey ---
**Author:** ![paul.stan](https://avatars.discourse-cdn.com/v4/letter/p/90ced4/32.png) [@paul.stan](https://forums.toadworld.com/u/paul.stan)\ **Post date:** [March 8, 2016, 1:38pm UTC](https://forums.toadworld.com/t/automation/35235/5 "2016-03-08T13:38:30Z")
I didn’t test run them all after I made the changes yesterday, I’m doing that now. I have only the largest one left and so far they’ve all run fine. That wouldn’t explain why it said they were run when they weren’t though. ---
**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\ **Post date:** [March 8, 2016, 2:00pm UTC](https://forums.toadworld.com/t/automation/35235/6 "2016-03-08T14:00:48Z")
I’m assuming “run fine“ means that the new Excel files are populated correctly. Now you have to reschedule the scripts again to be sure that the Job Manager uses the correct scripts. ---
**Author:** ![paul.stan](https://avatars.discourse-cdn.com/v4/letter/p/90ced4/32.png) [@paul.stan](https://forums.toadworld.com/u/paul.stan)\ **Post date:** [March 8, 2016, 2:47pm UTC](https://forums.toadworld.com/t/automation/35235/7 "2016-03-08T14:47:00Z")
That is correct. If they don’t run tonight, I’ll reschedule them. ---
**Author:** ![paul.stan](https://avatars.discourse-cdn.com/v4/letter/p/90ced4/32.png) [@paul.stan](https://forums.toadworld.com/u/paul.stan)\ **Post date:** [March 9, 2016, 7:40am UTC](https://forums.toadworld.com/t/automation/35235/8 "2016-03-09T07:40:46Z")
I did re-schedule them all yesterday, and the same thing happened again. Job Manager says that they all ran last night when they were supposed to but the excel files weren’t updated. ---
**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 9, 2016, 10:22am UTC](https://forums.toadworld.com/t/automation/35235/9 "2016-03-09T10:22:30Z")
Did you delete the old schedule and create a new one from the opened .tas file with your linked file changes in it? ---
**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 9, 2016, 10:23am UTC](https://forums.toadworld.com/t/automation/35235/10 "2016-03-09T10:23:57Z")
a real test would be not to run (Test run) but schedule it to run now. ---
**Author:** ![paul.stan](https://avatars.discourse-cdn.com/v4/letter/p/90ced4/32.png) [@paul.stan](https://forums.toadworld.com/u/paul.stan)\ **Post date:** [March 9, 2016, 10:24am UTC](https://forums.toadworld.com/t/automation/35235/11 "2016-03-09T10:24:55Z")
No. I went through Edit in Job Manager. ---
**Author:** ![paul.stan](https://avatars.discourse-cdn.com/v4/letter/p/90ced4/32.png) [@paul.stan](https://forums.toadworld.com/u/paul.stan)\ **Post date:** [March 9, 2016, 10:26am UTC](https://forums.toadworld.com/t/automation/35235/12 "2016-03-09T10:26:21Z")
I’ll try that later when I get some time. ---
**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 9, 2016, 10:33am UTC](https://forums.toadworld.com/t/automation/35235/13 "2016-03-09T10:33:40Z")
I had a problem like that in version of Toad (forgot which) where the job manager did not update the job in windows scheduler. I think it was deactivate that did not work. I would go into Windows Scheduler and you could see that the job manager change did not take place. Job manager just packages up all the scheduling information and passes it to Windows scheduler (makes it easy) but you may have run into an update problem. Never had problems on a new schedule though. ---
**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 11, 2016, 6:59pm UTC](https://forums.toadworld.com/t/automation/35235/14 "2016-03-11T18:59:27Z")
Greg the issue you mention with deactivate a task was an exiting error. We decided to fix it by upgrading the job manager to use the newer style task scheduling. this will be available in the next Beta. ---
**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 11, 2016, 7:21pm UTC](https://forums.toadworld.com/t/automation/35235/15 "2016-03-11T19:21:21Z")
Paul, what does the automation logs say? And what is the return code on the window task scheduler (use the one from the operating system) Here is a video I made a long time ago about how to debug an automation script. [www.toadworld.com/…/1120](http://www.toadworld.com/products/toad-data-point/m/media-library/1120) See if that helps. If not, I can get deeper into debugging this. ---
**Author:** ![paul.stan](https://avatars.discourse-cdn.com/v4/letter/p/90ced4/32.png) [@paul.stan](https://forums.toadworld.com/u/paul.stan)\ **Post date:** [March 14, 2016, 7:50am UTC](https://forums.toadworld.com/t/automation/35235/16 "2016-03-14T07:50:53Z")
I got the “0x6F” error on the Task scheduler for all. I have 10 now because I recreated them all in an attempt to correct things. I tried to go through the troubleshooter, but I can’t get into toad. I got this message: I was unable to get on on Friday all day with the same message. ---
**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 14, 2016, 5:43pm UTC](https://forums.toadworld.com/t/automation/35235/17 "2016-03-14T17:43:31Z")
The error code means there was an error but the script continued. I would suggest you add exception emails or at a minimum add an email at the end of the script that also sends the full log file. I go over how to do this in the video I referenced earlier. ---
**Author:** ![paul.stan](https://avatars.discourse-cdn.com/v4/letter/p/90ced4/32.png) [@paul.stan](https://forums.toadworld.com/u/paul.stan)\ **Post date:** [March 15, 2016, 7:41am UTC](https://forums.toadworld.com/t/automation/35235/18 "2016-03-15T07:41:57Z")
I’d like to try some of these things you’re suggesting, but every time I try to connect for the last 3 days, I get the connection timeout message, do you have any suggestions for that? ---
**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 16, 2016, 6:36pm UTC](https://forums.toadworld.com/t/automation/35235/19 "2016-03-16T18:36:04Z")
Try increasing your time out values. They are in the options under Database | Timeouts | Connection Timeout ---
**Author:** ![paul.stan](https://avatars.discourse-cdn.com/v4/letter/p/90ced4/32.png) [@paul.stan](https://forums.toadworld.com/u/paul.stan)\ **Post date:** [March 17, 2016, 8:24am UTC](https://forums.toadworld.com/t/automation/35235/20 "2016-03-17T08:24:55Z")
According to our IT, the problem has to do with our EHRS vendor Welligent. We upgraded our internet and that messed with our connection to Welligent. Something about our URL’s. We’re waiting for Welligent to do something on their end. Do you have any insight with that end of things? [Next page](https://forums.toadworld.com/t/automation/35235.md?page=2)