Publication Information, Agents (Transactional Publication)

The Agents tab displays summary information on the agents for the selected publication. Information on the Snapshot Agent and Log Reader Agent is displayed for all transactional publications. Information on the Queue Reader Agent is displayed for those transactional publications that are enabled for queued updating subscriptions.

Options

For more detailed information and tasks related to an agent, right-click the row for that agent, and then click an option on the shortcut menu. To change the way that the grid displays data, right-click the grid, and then click one of the following options:

  • Sort: Sort on one or more columns in the Sort Columns dialog box.

  • Choose Columns to Show: Select which columns to display and the order in which to display them in the Choose Columns dialog box.

  • Filter: Filter rows in the grid based on column values in the Filter Settings dialog box.

  • Clear Filter: Clear any filter settings for the grid.

Filter settings are specific to each grid. Column selection and sorting are applied to all grids of the same type, such as the publications grid for each Publisher.

  • Status
    The status of each replication agent associated with the publication. The following list shows the possible status values:

    • Error

    • Retrying failed commands

    • Not running

    • Running

    • Completed

  • Agent
    The name of each replication agent associated with the publication. The Distribution Agent is associated with subscriptions to this publication. For more information, see How to: View Information and Perform Tasks for the Agents Associated With a Subscription (Replication Monitor).

  • Last Start Time
    The last time the agent started.

  • Duration
    The amount of time the agent has run. The time represents elapsed time if the agent is currently running and total time if the agent has run previously.

  • Last Action
    The last action performed during the most recent run of the agent.