This discussion is archived
12 Replies Latest reply: Jul 19, 2012 10:48 AM by ebalthes RSS

Modify repeat_interval for Auto Sync Jobs

amin_adatia Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points