Toad World® Forums

Automation Assistance


#1

Hello,

We are fairly new to Toad DataPoint and have the following issues on two of the four machines we are using.

After creating scripts to run our SQL code and creating a schedule on the local machine the error of ORA - 12504 prevents these schedules from running. Any suggestions?


#2

That usually means you do not have your Oracle TNSNames.ora file correct. Make sure all clients have the same file, client and Toad connection.


#3

We have done that and get the same end result. The user having this issue can actually open Toad Data Point and run SQL files without any issues. It is only when we try to use the scheduler that this happens


#4

Is the same user the one running the script when scheduled? Did they put in their id and password when scheduling the task? And is the task run when the user is logged on?


#5

Is the same user the one running the script when scheduled? YES

Did they put in their id and password when scheduling the task? YES

And is the task run when the user is logged on? Yes, if the user is logged into Datapoint we can run the script and it finished without error.


#6

While the user is logged in go into the job manager (Tools/Administer/JobManager) and start the scheduled job from there (right click job and select start), not from the open .tas file. If it fails then something is not set up right on the job or the user does not have permisions to use the Windows task scheduler. Toad uses Windows task scheduler (just packages it up nice and easy for you).


#7

I would open a ticket with support. We can set up a webex call and see what is happening and debug.