Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Hi, Is there any way we can specify in the Synchronization Profile or in dbmlsync schedule to run the synchronization every 30 minutes (e={sch=every:00:30;}) between 6AM to 11PM.

It looks like the only way to do that is



The issue is, it is a pretty long string and I don't have any way to randomize the time within the interval so that multiple remote databases with the same schedule do not cause congestion at the MobiLink server by synchronizing at exactly the same time.

I'll appreciate the suggestions.

asked 27 Jul '15, 09:30

Chinmay1's gravatar image

accept rate: 0%

edited 27 Jul '15, 12:21

RussC_FromSAP's gravatar image


Here's a WAG...

Have you considered using a Server Initiated Synchronization listener and push request setup to let the server side decide when the remotes should synchronized? Then the schedule could be based on actual load rather than prayerful randomization :)

permanent link

answered 27 Jul '15, 17:42

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

Hi Breck,

I am not too sure if Server Initiated Synchronization can be implemented in our network topology. As I understand there are some limitations in this approach.

Device limitations when using UDP gateways •The IP address on the device must be addressable directly from the MobiLink server.

•IP tracking for UDP notification does not work if the IP address on a Windows device is not addressable directly from the MobiLink server.



(28 Jul '15, 10:57) Chinmay1
Replies hidden

The Listener can also work by polling the MobiLink server. See this tutorial for more information:

Something similar can also be done with server initiated remote tasks when using central admin of remotes: I don't know much about remote tasks, but it looks like they let you set a random delay interval which sounds like it's exactly what you want.

(28 Jul '15, 11:17) Bill Somers

Thanks Bill, Breck and Russ for your valuable inputs.

It seems like polling the MobiLink server may be the ideal solution for us. Central admin of the remotes is something we wanted to eventually achieve with Mobilink.



(29 Jul '15, 09:24) Chinmay1
Replies hidden

If there was a "Hallmarks of MobiLink" section in the Help (there isn't) one of the points would be "central administration of remotes".

Which means you should be able to find a solution, and if you can't there will be heck to pay :)

(29 Jul '15, 09:48) Breck Carter

You could consider generating more random times on a per-remote basis in the sch option above, but I don't know how easy that is to do in your environment. I suppose you wouldn't ask this question if it was easy.

A more programmatic approach is to use an event hook. See Synchronization initiation with event hooks. Using this approach you'd randomly delay the sync to initiate in each desired interval. A more predictable approach would be to use an integer hash of some remote-specific information, like a username, device name, remote id, whatever. This would spread the load and once it worked, you know it should continue to work. Using a random delay can cause spikes and headaches. For your sanity I suggest a non-random approach, if you can.

  • Russ
permanent link

answered 27 Jul '15, 10:42

RussC_FromSAP's gravatar image

accept rate: 18%

Hi Russ,

Thanks for your response. I am thinking about using 'sp_hook_dbmlsync_delay' and modify the #hook_dict. I understand that random spikes may cause some issues. I guess the best approach will be to test this change thoroughly.



(27 Jul '15, 11:23) Chinmay1

Hi Chinmay,

Thorough testing is always a good thing. :-)

Best Regards,

  • Russ
(27 Jul '15, 12:21) RussC_FromSAP
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 27 Jul '15, 09:30

question was seen: 2,407 times

last updated: 29 Jul '15, 09:48