Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Modify repeat_interval for Auto Sync Jobs

Amin AdatiaJul 18 2012 — edited Jul 19 2012

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2012

Added on Jul 18 2012

#database-key-features, #text

12 comments

550 views