Forums » General Discussion

Thread: Problem with automation

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 0 - Pages: 1 Threads: [ Previous | Next ]
jules

Posts: 1
Registered: 8/1/12
Problem with automation
Posted: Aug 1, 2012 5:47 AM
 
  Click to reply to this thread Reply

Hello everybody,

I've edited an automation script on Toad for MySQL which is composed of an import template within a connexion (the script imports data from a file to my database).

When I test this automation script with the "test automation script" button, it works! But when i try to launch this script automatically a few minutes latter, it doesn't work...at the launching time, i see that Toad for MySQL is laucnhed during a few seconds, but nothing is done : neither an open window, neither anything done in my database.

I've done many (many many..) tests that make me sure that the only issue in the script is the access to my database (for example, if in the script I remove the connection and let only the import, Toad is launched at the desired time and a window appears claiming my password for the database, once I enter it, the script is executed normally. other example : automation for copying or deleting files, so nothing to see with my database, works very good).

I work on this issue for 2 days...Does anyone have an idea?

Thank you very much


PS : I work with Toad for MySQL 5.0.0.345 and MySQL Server 5.5


Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums