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

Backup-restore-empty On One Schedule

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Backup-restore-empty On One Schedule

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • November 14, 2006 at 4:54 am #22913
      peterlaursen
      Participant

      There is one feature missing in 'Notifications Services' to make that possible with the SJA alone. And that is the option to to execute SQL from an external file. We plan to add this feature but not with high priority. It is not scheduled as neither 1st nor 2nd priority.

      The workaround: Schedule a batch file calling

      1) a SJA Backup Job

      2) a script/program executing the restore to 2nd machine

      3) a Notifications Service job executing 'TRUNCATE table …..'

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