Toad World® Forums

missing in action - batch


#1

I defined an action for database health check.
It runs fine when I activate it in TOAD.
I created a scheduled task for it, running as an administrator, and
tried to run it.
I see TOAD running for a few seconds and then the status of the task
show that it is nor running.
There is nothing in the log in TOAD.

What to check?


Adar Yechiel
Rechovot, Israel


#2

The most common cause of this type of problem is one doesn’t have ‘save passwords’ turned on. Scheduled Actions run by launching a separate Toad process, and it needs the password saved to disk in order to connect.


#3

Passwords are saved to disk.
Allow multiple copies of toad to be loaded is checked (in case I left toad
open).
In the task manager I see toad starting to run and disappearing after a few
seconds.

I open the app designer and open the logs and there is no mention of the run.

You really need to save userid and passwords for the actions in a separate
place.
Turning on the save password is really bad when toad is used on a server that
several people can access.
Everyone can double click the connection and get in.
Adar Yechiel
Rechovot, Israel

Mark Lerch wrote:

The most common cause of this type of problem is one doesn’t have ‘save
passwords’ turned on. Scheduled Actions run by launching a separate Toad
process, and it needs the password saved to disk in order to connect.


#4

You’re looking here for the log, right? Then you can double-click one of
them for details…. I’m trying to reproduce your problem, but it
seems to be working here.
image001.png


#5

What version of Toad are you running?

If you send me your

C:\Documents and Settings\Application Data\Quest Software\Toad for
Oracle\User Files\ToadActions.dat & ToadActions.log

I will try to diagnose.
image001.jpeg


#6

It is also working here on another machine.
The action does not appear in the list in the execution log.

Adar Yechiel
Rechovot, Israel

John Dorlon wrote:

You’re looking here for the log, right? Then you can double-click
one of them for details… I’m trying to reproduce your problem, but
it seems to be working here.

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] *On Behalf
Of *Yechiel Adar
Sent: Tuesday, October 27, 2009 12:40 AM
To: toad@yahoogroups.com
Subject: Re: [toad] missing in action - batch

Passwords are saved to disk.
Allow multiple copies of toad to be loaded is checked (in case I left
toad open).
In the task manager I see toad starting to run and disappearing after
a few seconds.

I open the app designer and open the logs and there is no mention of
the run.

You really need to save userid and passwords for the actions in a
separate place.
Turning on the save password is really bad when toad is used on a
server that several people can access.
Everyone can double click the connection and get in.

Adar Yechiel
Rechovot, Israel

Mark Lerch wrote:

The most common cause of this type of problem is one doesn’t have
‘save passwords’ turned on. Scheduled Actions run by launching a
separate Toad process, and it needs the password saved to disk in
order to connect.

It is also working here on another machine.
The action does not appear in the list in the execution log.
Adar Yechiel
Rechovot, Israel

John Dorlon wrote:

You’re looking here for the log, right? Then you can double-click one
of them for details…. I’m trying to reproduce your problem, but
it seems to be working here.
att1.dat (143 KB)


#7

You seemed to indicate you have Toad running on a server with multiple users
accessing it?

Actions are saved on the client machine, they can’t be shared that way.
They can only be executed by the machine which creates them.
image001.png


#8

In other words, toad.exe can’t execute an action that lies somewhere other
than the host machine?
image001.png


#9

Maybe they’re launching Toad from (and on) the server??
ie running the application in memory on the server with different people
accessing the server’s desktop.

Disclaimer:
I’m probably wrong and waiting to be told so … :slight_smile:
att1.dat (1.79 KB)


#10

Maybe they’re launching Toad from (and on) the server??
ie running the application in memory on the server with different people
accessing the server’s desktop.

Disclaimer:
I’m probably wrong and waiting to be told so … :slight_smile:
att1.dat (43 Bytes)


#11

Correct, unless the data file is copied.

When you create an Action/App it gets stored here:

C:\Documents and Settings\Application Data\Quest Software\Toad for
Oracle\User Files\ToadActions.dat

When you execute an Action (e.g., “Toad.exe –a SomeAction”),
Toad looks in ToadActions.dat for the Action.

If Toad is being executed on a server, if User A creates “MyAction,”
obviously, User B can’t execute it unless ToadActions.dat is copied across
to their Application Data folder, overwriting their own file. If User B tries to
execute an Action not in their data file, they will get an “Action not
found” message. That’s why I asked about the Toad version, to make
sure we were displaying that in all the earliest versions.
image001.jpeg


#12

Correct, unless the data file is copied.

When you create an Action/App it gets stored here:

C:\Documents and Settings\Application Data\Quest Software\Toad for
Oracle\User Files\ToadActions.dat

When you execute an Action (e.g., “Toad.exe –a SomeAction”),
Toad looks in ToadActions.dat for the Action.

If Toad is being executed on a server, if User A creates “MyAction,”
obviously, User B can’t execute it unless ToadActions.dat is copied across
to their Application Data folder, overwriting their own file. If User B tries to
execute an Action not in their data file, they will get an “Action not
found” message. That’s why I asked about the Toad version, to make
sure we were displaying that in all the earliest versions.
image001.png


#13

That’s what I keep asking. And I assume the licensing is legitimate. : )

I’m also interested if he is using the ‘Server’ Feature of the installer.
image001.jpeg