User's Manual

Chapter 18. Command Reference for Adaptive Server Enterprise
Argument Description
send_time A string containing a time specification with the
following meaning:
♦ If frequency is SEND EVERY, specifies a length
of time between messages.
♦ If frequency is SEND AT, specifies a time of day
at which messages will be sent.
If no frequency is specified, the Message Agent sends
messages, and then stops.
See also “sp_grant_remote procedure” on page 393
“sp_revoke_consolidate procedure” on page 431
“GRANT CONSOLIDATE statement” on page 364
Description If the Adaptive Server Enterprise server is acting as a remote database in a
SQL Remote installation, the single database above the current database
must be granted consolidated permissions using the sp_grant_consolidate
procedure.
The consolidated user is identified by a message system, identifying the
method by which messages are sent to and received from the consolidated
user. The address-name must be a valid address for the message-system,
enclosed in single quotes.
The sp_grant_consolidate procedure is required for the remote database to
receive messages, but does not by itself subscribe the remote user to any
data. To subscribe to data, a subscription must be created for the user ID to
one of the publications in the current database.
The optional frequency argument specifies a frequency at which messages
are sent. The send_time argument contains a time that is a length of time
between messages (for SEND EVERY) or a time of day at which messages
are sent (for SEND AT). With SEND AT, messages are sent once per day.
If no frequency argument is supplied, the Message Agent processes
messages, and then stops. In order to run the Message Agent continuously,
you must ensure that every user with remote or consolidated permission has
a frequency specified.
Example
♦ The following statement grants consolidated permissions to user
hq_user, using a file sharing system, sending messages to the address
hq_dir: No frequency arguments are specified, and the Message Agent
will run in batch mode.
391