Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
You can set up dbmlsync to synchronize periodically based on rules you define. There are two ways you can set this up:
Use the dbmlsync extended option SCHEDULE to initiate synchronization at specific times of the day or week or at regular intervals. In this case, dbmlsync remains running until stopped by the user.
Use dbmlsync event hooks to initiate synchronization based on logic that you define. This is the best way to implement synchronization at irregular intervals or in response to an event. In this case, you can stop dbmlsync programmatically from your hook code.
When scheduling options or hooks are specified, dbmlsync goes into hovering mode. Hovering is a feature that reduces the amount of time spent scanning the log. You can improve the performance benefits of hovering by setting the dbmlsync extended option HoverRescanThreshold or by using the dbmlsync stored procedure sp_hook_dbmlsync_log_rescan.
For more information, see:
Setting up scheduling with dbmlsync options
Initiating synchronization with event hooks