ra_helpsrvsession

Syntax

ra_helpsrvsession [sessionID | all]

Parameters

• sessionID – The numerical identifer of a particular session.
• all – the keyword to view all active Replication Agent client sessions.

Examples

• Example 1 –

  ra_helpsrvsession
  go
  Id       Start Time           Last Command Time    Last Command
  -------- -------------------- -------------------- ------------------
  9527210  01/10/2014 21:33:48  01/10/2014 21:34:36  ra_helpsrvsession
  
  (1 row affected)

  This command returns information for the current session only.

• Example 2 –

  ra_helpsrvsession all
  go
  
  Id        Start Time           Last Command Time    Last Command
  --------- -------------------- -------------------- ----------------------
  14680795  01/08/2014 21:54:08  01/10/2014 21:34:23  ra_version_all
  9527210   01/10/2014 21:33:48  01/10/2014 21:34:39  ra_helpsrvsession all
  
  (2 rows affected)

  This command returns information for all active sessions.

• Example 3 –

  ra_helpsrvsession 14680795
  go
  
  Id        Start Time           Last Command Time    Last Command
  --------- -------------------- -------------------- ---------------
  14680795  01/08/2014 21:54:08  01/10/2014 21:34:23  ra_version_all
  
  (1 row affected)

  This command returns information for the specified session ID .

Usage

• If ra_helpsrvsession is invoked with no parameter, it returns information for the current Replication Agent client session.

• If ra_helpsrvsession is invoked with the keyword all, it returns information for all active Replication Agent client sessions.

• If ra_helpsrvsession is invoked with a session ID, it returns information for the specified Replication Agent client session ID.