Use the following procedure to run SQL Remote in batch mode.
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 SQL Remote Message Agent (dbremote) using the -b option.
Start the SQL Remote Message Agent (dbremote).
On Windows, the SQL Remote 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 SQL Remote Message Agent (dbremote).
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 SQL Remote 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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|