Sybase DC38133-01-0902-01 manual Selecting a send frequency

	♦ Send message daily, at 10 p.m.
	GRANT REMOTE TO S_Beaulieu
	TYPE smtp
	ADDRESS ’s_beaulieu@acme.com’
	SEND AT ’22:00’
Adaptive Server	The following statement grants remote permissions to user S_Beaulieu with
Enterprise example	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