Solved

MSreplication_agent_status what are the possible status codes?

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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

717 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