Solved

MSreplication_agent_status what are the possible status codes?

Posted on 2009-03-31
2
437 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
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

822 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