Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Batch Files

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Batch Files

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • March 23, 2006 at 2:40 pm #9558
      rtk
      Member

      I have a scheduled import of ODBC data into a MYSQL 5 database. It was created with SQLyog.

      What I would like to do once this import happens is to run a query which makes a table and then upload this table to my web server. I have the create table query created already in the form of .sql file.

      Any suggestions on how I can make this all happen automatically?

      Thanks,

      Russ

    • March 23, 2006 at 3:10 pm #20970
      peterlaursen
      Participant

      well …

      With SQLyog Enterprise you can use Notifications Services to execute SQL with the SJA. You can build a batch file with more SJA-instances as explained here: http://www.webyog.com/faq/27_35_en.html . Each instance of course can connect to different servers.

      The batch file can be scheduled with the built-in or a third-party scheduler

      The .SQL files(s) is/are not executable(s) themselves and can't be scheduled!

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.