Use the following procedure to run SQL Remote in batch mode. For information about batch mode and its alternative, continuous mode, see Understanding the Message Agent (dbremote).

To run the Message Agent (dbremote) in batch mode

1. Ensure that at least one remote user has neither a SEND AT nor a SEND EVERY option in their remote properties.

   If all of your remote users have a SEND AT or a SEND EVERY clause defined, and you want to send and receive messages and then shut down, you must start the Message Agent (dbremote) using the -b option.

2. Start the Message Agent (dbremote).

   On Windows, the Message Agent (dbremote) is named dbremote.exe. On Unix, the name is dbremote. On Mac OS X, you can also use SyncConsole to start the Message Agent (dbremote). See Run the Message Agent (dbremote) on Mac OS X and Run the Message Agent (dbremote) on Unix.

   For example, the following statement runs dbremote in batch mode on a database file named c:\mydata.db, connecting with user name ManagerSteve and password sql:

   dbremote -c "UID=ManagerSteve;PWD=sql;DBF=c:\mydata.db"

   The Message Agent (dbremote) receives and processes incoming messages, scans the transaction log once, creates and sends the outgoing messages, and then stops.

   The username, ManagerSteve, must have either REMOTE DBA authority or DBA authority. The maximum message length, as defined by the -l option, must be the same for all databases in the system. See Message Agent (dbremote) requirements.

See also

• Message Agent (dbremote)