I have been using SQLyog for some years now and it has served its purpose well. I have a new challenge and I can't quite figure out if the program can meet the goal or not, hence this post.
This is what I want to accomplish. The hosting company I am using does not support the use of triggers in mysql because it requires super access, therefore I am thinking I would need to create a stored procedure to accomplish my same goal.. and here is how I want it to work (please let me know if it is possible and how or is there an alternative). I want to schedule a flat file import to update a table while at the same time I want a stored procedure to run to make calculations based on the loaded data and I want this to all be automated =). Help!
Answer thanks to Peter Laursen:
yes .. you may use the 'notifications service' feature. The SQL to be executed will be two statements:
LOAD DATA LOCAL INFILE.. ;
CALL the_procedure().
The exact syntax for the LOAD statement can be copied from SQLyog HISTORY tab after executing 'CSV import using LOAD DATA' manually once (just in case you have problems writing such statement out of your head)..
A FAQ:
webyog.com/faq/content/27/114/en/introduction-to-the-_sqlyog-job-agent_-sja.html
