MSrepl_agent_jobs does not exists

Share this Post

Are you trying to setup replication in an AlwaysOn Availability Group environment? Are you seeing this error?

Msg 14262, Level 16, State 1, Procedure sp_MSrepl_track_addjob, Line 57 [Batch Start Line 27] 

The specified table ('MSrepl_agent_jobs') does not exist.

 

MSrepl_agent_jobs is a new table added to Distribution database in SQL 2017 CU6 and SQL 2016 SP2-CU3 to support Replication in an AlwaysOn Availability Group environment.

https://docs.microsoft.com/en-us/sql/relational-databases/replication/configure-distribution-availability-group
SQL Server 2017 CU6 and SQL Server 2016 SP2-CU3 introduces support for replication distribution database in an AG”

This table contains the SQL Server Agent Replication jobs information and queried by the new SQL Server Agent job “Monitor and sync replication agent jobs”. This job calls sp_MSrepl_monitor_job_at_failover ensuring the required Replication Jobs are created and configured on each replica with the correct listener names following an Availability Group failover.

— Name: sp_MSrepl_monitor_job_at_failover


— Descriptions: Synchronize replication agent jobs to the new primary replica after

— an availability group failover. Also enable distribution database

— associated SQL Agent jobs on primary replica and disable them on

— secondary replica.

When setting up replication with AlwaysOn Availability Groups, ensure the Distribution role server has been upgraded to at least SQL 2016 CU6 or SQL 2016 SP2-CU3 and your running 17.9 version of SQL Server Management Studio containing the updated Replication Monitor.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms


 


Share this Post

About: ReplTalk


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.