The profile for the replication agent has a ‘query timeout’ value that can be changed to ensure that the queries have sufficient time to complete. Read more about this option in this article.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help