SQL Remote User's Guide
System Objects for Adaptive Server Enterprise
SQL Remote system tables
To ensure that messages received by the Message Agent are sent to remote databases in the same session.
Column | Data type | Description |
---|---|---|
marker | DATETIME | A time value indicating when the latest messages were applied. |
When a consolidated database uses two Message Agents, one to populate the stable queue (-i
) and one to receive and send messages (-r
-s
), the single row of the sr_marker table is used to ensure that messages received and applied to the database are sent before the Message Agent closes down.