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.
thewayne73Asked:
Who is Participating?
 
Stephan_SchrandtConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.