Contents Index sr_articlecol table sr_object table

SQL Remote User's Guide
  System Objects for Adaptive Server Enterprise
    SQL Remote system tables

sr_marker table


Function 

To ensure that messages received by the Message Agent are sent to remote databases in the same session.

Columns 
Column Data type Description
marker DATETIME A time value indicating when the latest messages were applied.
Description 

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.


Contents Index sr_articlecol table sr_object table