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

Can The Job Agent Execute Arbitrary Sql In A Database?

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Can The Job Agent Execute Arbitrary Sql In A Database?

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • August 27, 2007 at 5:37 pm #10506
      rani
      Member

      I am looking for an OS neutral mysql job scheduling utility. The sqlyog job agent looked like a good fit, but on reading more, it does not appear to be able to run sprocs or sql statements against databases. Can anyone confirm this? Does anyone know of an alternative approach?

    • August 27, 2007 at 7:55 pm #24754
      peterlaursen
      Participant

      I think a 'sproc' is a Stored Procedure?

      SJA consist of 4 'modules':

      *Data sync

      *Migration (ODBC)

      *Scheduled Backup

      *Notifications Services

      You can call a 'sproc' from Notifications Services, refer to:

      http://webyog.com/faq/content/27/114/en/in…agent_-sja.html

      http://webyog.com/faq/content/14/81/en/is-…s-service_.html

      Peter Laursen

      'wyfwad' (WebYog Forums WAtchDog) 😉

    • August 27, 2007 at 8:49 pm #24755
      rani
      Member

      Yes, sproc = stored procedure.

      I only have the community version of sqlyog. Do I need the enterprise version to be able to use job agent?

      Thanks

    • August 28, 2007 at 8:03 am #24756
      peterlaursen
      Participant
      Code:
      Do I need the enterprise version to be able to use job agent?

      SJA or Windows comes with SQLyog ENTERPRISE only. SJA for Linux is free.

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