Connection Status Event Arguments

Describes the arguments of a connection status event.

There are two types of connections—inbound and outbound. An inbound connection is a connection to a Replication Server from a database via a Replication Agent. An outbound connection is a connection from a Replication Server to a database.

Connection Status Event Trigger Arguments

Argument

Description

connection

Keyword identifying the event as a connection status event.

date_time

The date and time the event occurred. Format: Month Day Year HH:MM:SS:TTTMeridian

rms

The name of the RMS that executed the event script.

object_id

The server where the event occurred.

source_type

The type of server that raised the event. Values are:
  • repserver

  • database

source_name

The name of the Replication Server or data server that raised the event.

ra_type

Type of Replication Agent. Values are:
  • rep agent

  • rep agent thread

  • dbltm

  • Empty string ('') if connection is outbound.

ra_name

Replication Agent name. Empty string ('') if connection is outbound.

dest_type

The destination server type. Values are:
  • repserver

  • database

dest_name

Destination server name.

state

The new connection status.