12 Replies Latest reply: Jul 19, 2012 12:48 PM by Ebalthes-Oracle RSS

    Modify repeat_interval for Auto Sync Jobs

    amin_adatia
      Is it "permitted/supported" to modify the repeat_interval for Auto Sync Index jobs created when using the syntax SYNC(EVERY "SYSDATE + 30/86400") which give a repeat interval of 30 seconds

      I do not want to have partitions older than a (sysdate-3) days and none greater than "sysdate" to be running. I create new partitions daily and so would like to start/stop partition jobs for the sync window. If I get data outside the window, say 7 days old, then I would run that specific partition sync manually.

      Is there a way to define the interval to be a moving window?

      Regards