SQL Remote User's Guide
SQL Remote Administration
Managing SQL Remote permissions
Granting and revoking REMOTE and CONSOLIDATE permissions
There are three alternatives for the setting the frequency with which messages are sent. The three alternatives are:
SEND EVERY A frequency can be specified in hours, minutes, and seconds in the format 'HH:MM:SS'.
When any user with SEND EVERY set is sent messages, all users with the same frequency are sent messages also. For example, all remote users who receive updates every twelve hours are sent updates at the same times, rather than being staggered. This reduces the number of times the Adaptive Server Anywhere transaction log or Adaptive Server Enterprise stable queue has to be processed. You should use as few unique frequencies as possible.
SEND AT A time of day, in hours and minutes.
Updates are started daily at the specified time. It is more efficient to use as few distinct times as possible than to stagger the sending times. Also, choosing times when the database is not busy minimizes interference with other users.
Default setting (no SEND clause) If any user has no SEND AT or SEND EVERY clause, the Message Agent sends messages every time it is run, and then stops: it runs in batch mode.
In Sybase Central, you can specify the send frequency in the following ways:
When you make an existing user or group remote. For more information, see Granting REMOTE permissions.
On the SQL Remote tab of the property sheet of a remote user or group. You can access the property sheet by right-clicking the remote user or group and choosing Properties from the popup menu.