PublicationMonitor.EnumQueueReaderAgent Method
Returns information for the Queue Reader Agent job used by the monitored publication.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
Syntax
'Declaration
Public Function EnumQueueReaderAgent As DataSet
'Usage
Dim instance As PublicationMonitor
Dim returnValue As DataSet
returnValue = instance.EnumQueueReaderAgent()
public DataSet EnumQueueReaderAgent()
public:
DataSet^ EnumQueueReaderAgent()
member EnumQueueReaderAgent : unit -> DataSet
public function EnumQueueReaderAgent() : DataSet
Return Value
Type: System.Data.DataSet
A DataSet object that contains the following columns.
Column |
Data type |
Description |
|---|---|---|
name |
Replication Agent job name. |
|
status |
The running status: 1 = Start 2 = Succeed 3 = In progress 4 = Idle 5 = Retry 6 = Fail |
|
start_time |
Date and time of last agent execution. |
|
time |
Date and time that the session was logged. |
|
duration |
Elapsed time of the session, in seconds. |
|
comments |
Message text logged by the agent. |
|
transactions_processed |
Total number of transactions processed in the session. |
|
commands_processed |
Total number of commands processed in the session. |
|
average_commands |
Average number of commands per transaction delivered in the session. |
|
delivery_rate |
Average number of commands delivered per second. |
|
delivery_latency |
The time, in milliseconds, between a command being read from the queue at the Subscriber and being committed to the publication database. |
|
error_id |
The ID of the error in the MSrepl_errors (Transact-SQL) system table. Use the EnumErrorRecords method to return detailed information about an error. |
|
job_id |
Byte[16] |
Identifier of the SQL Server Agent job starting the replication agent. |
local_job |
When true, the agent job is available at the Distributor. |
|
profile_id |
Profile identifier. |
|
agent_id |
Agent job identifier. |
|
local_timestamp |
Byte[8] |
Timestamp of the most recent agent run. |
Remarks
The EnumQueueReaderAgent method can only be called by members of the db_owner or replmonitor fixed database roles on the distribution database.
See Also
Reference
Microsoft.SqlServer.Replication Namespace