Hey Chris,
Can you forward us your ToadActions.dat file as Greg previously mentioned? After our first round of troubleshooting, that may be what we need to help track
this issue down.
Thanks!
-John
From: crjohnso [mailto:bounce-crjohnso@toadworld.com]
Sent: Friday, December 13, 2013 11:55 AM
To: toadoraclebeta@toadworld.com
Subject: RE: [Toad for Oracle - Beta Discussion Forum] Automation designer questions
RE: Automation designer questions
Reply by crjohnso
Not dropping support, just not selling Win7 any more in favor of Win8 and upcoming 8.1. I’m sure it will take a year or two to filter it out of the market stream,
but like XP it will be around for a decade.
1a – I think so. Not sure how to tell though. If I remember correctly it asks for credentials and I’m pretty sure I put in my own, same as running it online.
1b – Yes.
1c – Yes. Definitely. Input file, no output. It always has been, but could be an XP vs. Win7 thing. It’s a trivial script (just a delete … where… and commit).
I have no problem removing the file and embedding the script directly if that makes it work.
2 – It’s entirely possible that I changed the name. I looked to make sure it ran and saw that it failed and couldn’t see it scheduled and probably rescheduled
with a slightly different name before I figured out that Task Scheduler has a tree structure and I wasn’t seeing the Quest/Toad node until I expanded the tree. I think I had it scheduled a couple of times under slightly different names.
I just ran it through task scheduler making sure that my credentials are valid and it’s running with highest privilege. Still fails.
It looks like embedding the code directly rather than in a file works. In this case it’s a simple script and I don’t mind, but I could foresee situation where
that wouldn’t be acceptable. Do you want to continue down this path and see if we can figure it out?
From: John Bowman [mailto:bounce-jbowman@toadworld.com]
Sent: Friday, December 13, 2013 9:27 AM
To: toadoraclebeta@toadworld.com
Subject: RE: [Toad for Oracle - Beta Discussion Forum] Automation designer questions
RE:
Automation designer questions
Reply by John Bowman
Hey Chris,
Congratulations on getting off XP and on Windows 7!! Just an fyi – I haven’t heard anything about them dropping Win7. In fact, according to their Support
Lifecycle Policy:
http://support.microsoft.com/lifecycle/?LN=en-us&x=12amp;y=13#tab1
http://support.microsoft.com/gp/lifepolicy
you should have Extended support through January 2020:
http://support.microsoft.com/lifecycle/?p1=14481
In answer to your questions:
-
The error you’re receiving is generated by Toad within the Automation Designer. There are a couple of things that could be an issue:
a.
Are you running the task with the same credentials as when you run Toad manually?
b.
Are you running the task with “highest privileges”?
c.
Is the file or output directory located on a networked folder or mapped drive?
Windows 7 uses Task Scheduler 2.0 whereas Windows XP used Task Scheduler 1.0. They may have some similar options, but they do behave
a bit differently behind the curtain. It’s possible that permissions may be a bit off in order for Windows 7 to access the file in question, where this may not have been an issue with Windows XP. In addition, if the file is on a networked or mapped drive,
the Windows API call that checks to see if the file exists may return an incorrect result if the permissions are not set properly.
-
It should already notify you that the task has been created. I just ran a few tests on my Windows 7 machine and it let me know the task with that name already existed.
Unless, are you naming them different names? Because then you can create multiple tasks with the same actions.
-John
From: Chris Johnson [mailto:bounce-chrisjohnson@toadworld.com]
Sent: Friday, December 13, 2013 9:25 AM
To: toadoraclebeta@toadworld.com
Subject: [Toad for Oracle - Beta Discussion Forum] Automation designer questions
Automation
designer questions
Thread created by Chris Johnson
I just recently got upgraded by my company to a new laptop with Win 7. Yay! Finally off XP! (Ironically the same week M$ announces they re dropping Win7 I finally upgrade to it, but I digress)
As part of the upgrade I had to reschedule some automation designer items. I have one running three times a week and one running every day. I’m running into an issue I can’t figure out with
the daily one.
It is set up to run a file every day, but it has been failing saying “Execute Script1 (Execute Script) failure: Nothing specified to execute”, but when I look at the properties of Execute Script1
it shows the file and I can immediately click Run and it works like it always has, it just fails when the scheduler runs it. Suggestions?
Also I’m wondering, when I click to schedule a task that is already scheduled shouldn’t it show that somehow, even if only to say “this is already scheduled”? I scheduled something to run three
times because I thought the schedule setup was failing before I thought to look in the Windows scheduler to find it there already.
To reply, please reply-all to this email.
Stop
receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag
this post as spam/abuse.
To reply, please reply-all to this email.
Stop
receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag
this post as spam/abuse.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag
this post as spam/abuse.
