Adjusting the send delay

To create messages to send, the SQL Remote Message Agent (dbremote) polls for new data from the transaction log. The send delay is the time to wait between polls for more transaction log data to send. The default polling interval from the end of one poll to the start of another is 1 minute. You can configure the send delay using the -sd option, but the default is generally sufficient. The send delay should be less than or equal to the remote users' send frequency.

Decreasing the send delay

Increasing the send delay

You can poll less frequently, as in the following command, which polls every 60 minutes:

dbremote -c "DSN=SQL Anywhere 12 Demo"  -sd 60

Typically, larger send intervals mean that the SQL Remote Message Agent (dbremote) does most of the message creation work before sending the messages. Smaller intervals are generally preferred as they spread out the message creation work.

See SQL Remote Message Agent utility (dbremote).

Adjusting the send delay

Decreasing the send delay

Increasing the send delay

See also