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

Queries Time Driven?

forums › forums › SQLyog › Using SQLyog › Queries Time Driven?

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • February 13, 2007 at 12:07 pm #23407
      peterlaursen
      Participant

      two ways (at least):

      1) With MySQL 5.1 and 5.2 you can create an EVENT.  You can only send one query as an event, but if you put it all into one store proced

      re and all you need to do is the create an EVENT executing 'CALL my_sp()'

      2) With all MySQL versions you can let SQLyog/SJA Notifications do.  Notifications Services is an ENTERPRISE feature only.  Schedule the job to run from the client (of course client machine must then be on!). Now try starting the wizard from the 'powertools' menu and you will probably find out. You can add an unlimited number of queries and won't need to run inside a SP.

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.