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

Notification Service

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Notification Service

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • October 21, 2006 at 3:03 pm #9979
      Ian
      Member

      Hello.

      I am using the notification email service to execute various queries on my databases. This works fine with select statements (I get the query and the result in my email) but if I send a maintenance statement such as ALTER TABLE… I get a blank email, with no query, or response such as '1 row affected'.

      I also would like to request the ability to execute batch files from saved queries, I can't use INFILE since the db is remote, and editing the batch file to include the xml isn't really practical given the size of the batch file – I am importing binary data into blobs.

      Thanks

      Ian

    • October 23, 2006 at 4:19 am #22811
      peterlaursen
      Participant

      1) You will only have RESULTs mailed. And the RESULT of a ALTER TABLE is 'x rows affected'!

      You can have more SQL statements seperated by semicolon and just add a SELECT statement at the end.

      2) The option to execute external files in Notifications was discussed in-houiser her as late as Friday. Actually we have the code for it in 'favorites' allready … so this we intend to do!

    • October 26, 2006 at 4:23 am #22812
      Ian
      Member

      I was hoping for the query + 'x rows affected' but I get a completely blank email. If I add a select statement before or after the alter, I get the query and result for the select only.

    • October 26, 2006 at 5:22 am #22813
      peterlaursen
      Participant

      That is expected behaviour. But I think you request is reasonable! Give us a little time to discuss this.

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