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 1 reply thread
  • Author
    Posts
    • November 14, 2006 at 12:59 am #10016
      dhartn tea
      Member

      I need event regularly (daily) like below:

      1. backup table on machine1

      2. restore this backup into machine2

      3. empty table on machine1

      is possible this event does on one schedule? how SJA do that? on windows based or linux based…

      thks

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