Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 466
  • Last Modified:

MSreplication_agent_status what are the possible status codes?

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
gfahrlander
Asked:
gfahrlander
2 Solutions
 
reb73Commented:
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
 
gfahrlanderAuthor Commented:
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

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now