Updates are missed during stored procedure

[mikemayo]

Hi.

I am running a stored procedure as a job run with the SQL Server scheduler. This job runs every 5 minutes. The server is also running merge replication every 2 minutes. The problem is that intermitantly updates in the stored procedure are missed.

Is it possible to run another process whilst Merge Replication is running?

Thanks in advance.
Mike Mayo

 

[ChrisCarroll]

I don't know - but I suppose as an option you could change your update job to run every 4 minutes or every 6 minutes instead of 5 minutes, and then you can time it to not overlap with the merge replication (assuming each process takes less than 2 minutes to complete)