User's Manual

♦ Send message daily, at 10 p.m.
GRANT REMOTE TO S_Beaulieu
TYPE smtp
ADDRESS ’[e-mail]’
SEND AT ’22:00’
Adaptive Server
Enterprise example
The following statement grants remote permissions to user S_Beaulieu with
the following options:
♦ Use the file-sharing system to exchange messages.
♦ Place messages in the directory beaulieu under the address root directory.
The address root directory (for both Adaptive Server Anywhere and
Adaptive Server Enterprise) is indicated by the SQLREMOTE
environment variable, if it is set. Alternatively, it is indicated by the
Directory setting in the FILE message control parameters (held in the
registry or INI file).
♦ Send messages every twelve hours:
exec sp_grant_remote ’S_Beaulieu’,
’file’,
’beaulieu’,
’SEND EVERY’,
’12:00’
go
Selecting a send frequency
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.
206