SQL Server Replication Error: SQLServerAgent Error - Job already running from request by User sa

Question

I'm encountering an issue with SQL Server replication. After setting up a publication on my CampusNet2 database and attempting to synchronize it with CampusNet, I'm seeing errors related to the SQL Server Agent. Specifically, when trying to view the synchronization status, I receive the following error:

I successfully generated a snapshot for the publication on CampusNet2.

Below is the structure:

I'm looking for guidance on resolving this error, specifically understanding why the SQLServerAgent job is being refused due to it being already in progress. How can I troubleshoot this issue to ensure that the replication process completes successfully?

Answer 1

Hi，kevin stani

The cause of this issue may be due to the SQL Server Agent job running longer than the interval between executions. Perform the following configuration, and if the problem persists, try setting it to 60 minutes.

USE master
GO

exec sp_changedistributor_property 
        @property = 'heartbeat_interval', 
        @value = 30;

Regards

Mikey Qiao

---

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.