Run the SQL Remote Message Agent (dbremote) in continuous mode

Typically, the consolidated database is run in continuous mode.

 Run the SQL Remote Message Agent (dbremote) in continuous mode
  1. Ensure that every user with REMOTE authority either has a SEND AT or SEND EVERY frequency specified.

    In continuous mode, the SQL Remote Message Agent (dbremote) sends messages at times specified by the SEND AT or SEND EVERY frequency in the properties of each remote user.

  2. Start the SQL Remote Message Agent (dbremote) without the -b option.

    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 continuous 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" -l 40000

    The user name, 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 also
 Running the SQL Remote Message Agent (dbremote) as a service in continuous mode
 See also

Setting the send frequency