SQL Remote Confusion

[Former Member]

Hello,

we start our dbremote service with a text file that begins "-s -r -rd 10 -rp 3 -c "eng=..........

In Sybase Central each remote user is set to Send Every 01:00. Is this an hour or a minute? The service seems to be sending and receiving at odd times, although I might be misunderstanding the results from sysremoteusers.

With the settings above, if the consolidated db commits a transaction at 12:10, when would the update be expected to execute in the remote db. Likewise if the remote db commits a transaction at 12:20, when would the update be expected to execute on the consolidated db.

I'm sure this is quite simple but I just seem to can't figure it out.

Thanks, Paul

[VolkerBarth · Accepted solution]

The syntax for the SEND EVERY command is 'hh:mm:ss' - if you use "01:00" and that way omit the seconds part, then you have specified 1 hour.