Solved

MSreplication_agent_status what are the possible status codes?

Posted on 2009-03-31
2
442 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
ms sql and asp dates 5 41
Create a Calendar table 29 40
What does "Between" mean? 6 38
SQL query to retrieve alphabetical characters only from nvarchar string 16 47
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

738 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