by default a remote query (Query using Linked Server) expires in 10 mins. We can find this value in SQL Server using below queries
SELECT * FROM sys.sysconfigures WHERE comment ='remote query timeout' --or SELECT * FROM sys.configurations WHERE name='remote query timeout (s)'
We can find more details in MS doc
http://msdn.microsoft.com/en-us/library/ms189631.aspx
in order to change it we have to sp_configure and we don’t need to restart the database engine
sp_configure 'remote query timeout',3600 go reconfigure with override go
This will set the time out to 3600 seconds/ 1 hr