There are dbmlsync event hooks that you can implement to control when synchronization occurs.
With the sp_hook_dbmlsync_end hook, you can use the Restart row in the #hook_dict table to decide at the end of each synchronization if dbmlsync should repeat the synchronization.
For more information, see sp_hook_dbmlsync_end.
With the sp_hook_dbmlsync_delay hook you can create a delay at the beginning of each synchronization that allows you to choose the time to proceed with synchronization. With this hook it is possible to delay for a fixed amount of time or to poll periodically, waiting for some condition to be satisfied.
For more information, see sp_hook_dbmlsync_delay.
This method is not available when the Dbmlsync API or the SQL SYNCHRONIZE statement is used.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|