Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 164
  • Last Modified:

Job on seperate server is timing out

Hello experts,

I have a set of jobs that I run on one of our servers (Server 1).  One of the jobs executes a stored proc on another server (Server 2), but it not finishing.  Instead I received this:

OLE DB provider "SQLNCLI" for linked server "Server 2" returned message "Query timeout expired".

How can I prevent this?  The job is copying tables from Server 1 to Server 2.
0
thewayne73
Asked:
thewayne73
  • 2
  • 2
1 Solution
 
Stephan_SchrandtCommented:
Open the 2. server instance in Management Studio and set server timeout in instance properties to a higher value (default is 600 seconds)
0
 
thewayne73Author Commented:
thanks.. but i'd rather not mess with the server 2.. that is our production server.  
0
 
Stephan_SchrandtCommented:
From start of procedure to timeout, how many seconds elapse?
0
 
thewayne73Author Commented:
Thanks, I went ahead and did that for only the link that i'm using.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now