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 1 reply thread
  • Author
    Posts
    • February 13, 2007 at 11:39 am #10180
      fifo
      Member

      hi,

      i have some very complex queries in mysql. i have the enterprise edition of sqlyog and i want to know if it's possible to start queries (or stored procedures) time driven overnight?

      kind regards

      rainer

    • 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 1 reply thread
  • You must be logged in to reply to this topic.