Solved

MSreplication_agent_status what are the possible status codes?

Posted on 2009-03-31
2
441 Views
Last Modified: 2012-05-06
What are the status codes for the status column of MSreplication_agent_status?
I've learned 1, 3 & 4 are 'running' but can't find information on exactly what they each mean or what other possible values exist.

Thanks in advance,
Gary
0
Comment
Question by:gfahrlander
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 25

Assisted Solution

by:reb73
reb73 earned 100 total points
ID: 24032399
The system stored procedure - master.dbo.sp_msload_replication_status (undocumented ) - has the following code in its contents -

                when 0 then 5   -- Fail mapping  
                when 1 then 2   -- Success mapping  
                when 2 then 5   -- Retry mapping  
                when 3 then 2   -- Shutdown mapping  
                when 4 then 3   -- Inprogress mapping  
                when 5 then 0   -- Unknown is mapped to never run

Does this help?
0
 

Accepted Solution

by:
gfahrlander earned 0 total points
ID: 24032702
stumbled upon this... and when added to your answer it all comes together...

Table: tempdb.dbo.MSreplication_agent_status

Publication Type Codes (publication_type):
0 = Transactional publication
1 = Snapshot publication
2 = Merge publication

Replication Agent Type Codes: (agent_type)
-1 = SQLDMOReplAgent_/Publishers -- Agents supporting publishers
0 = SQLDMOReplAgent_All -- All replication agent types
1 = SQLDMOReplAgent_Snapshot -- Snapshot Agent
2 = SQLDMOReplAgent_LogReader -- Replication transaction Log Reader Agent
3 = SQLDMOReplAgent_/Distribution -- Distribution Agent
4 = SQLDMOReplAgent_Merge -- Merge Agent
5 = SQLDMOReplAgent_/Miscellaneous -- Agents not otherwise classified
9 = SQLDMOReplAgent_/QueueReader -- Replication Queue Reader Agent

Replication Agent Status Codes: (status)
0 = SQLDMOTask_Pending -- All agent-implementing jobs are waiting to start.
1 = SQLDMOTask_Starting -- One or more agent-implementing jobs are starting.
2 = SQLDMOTask_Succeeded -- All agent-implementing jobs have executed successfully.
3 = SQLDMOTask_Running -- At least one agent-implementing job is executing.
4 = SQLDMOTask_Idle -- All agent-implementing jobs are scheduled and idle.
5 = SQLDMOTask_Retry -- At least one agent-implementing job is attempting to execute after a previous failure.
6 = SQLDMOTask_Failed -- At least one agent-implementing job has failed to execute successfully.

References:       http://technet.microsoft.com/en-us/library/ms144002.aspx
            http://technet.microsoft.com/en-us/library/ms186254(SQL.90).aspx
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Conditions in Where clause 9 46
SQL Job Hung 17 37
Need time in SQL 8 30
Storage and Retrieval of ISO-8601 Format Date/Timestamp Records in Access / SQL Server 10 17
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question