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 184.108.40.2065 and MySQL Server 5.5