Post reply

time-out in a Job using link server

  • April 29, 2014 at 12:45 pm

    #307093

    i have this error in a job, this job is using linked server

    Message

    Executed as user: Domain\user. OLE DB provider "SQLNCLI10" for linked server "Report_Link_Server" returned message "Query timeout expired". [SQLSTATE 01000] (Message 7412). The step succeeded.

    any idea to resolved this error ?

  • April 30, 2014 at 2:59 pm

    #1710018

    Any Idea ?

  • May 1, 2014 at 4:24 am

    #1710059

    Please check the settings for

    linked server properties -> security options -> query timeout

    and

    SQL Server instance -> connections->remote server connections -> remote query timeout

    and compare it to the query processing time when running the query (referenced in the job step) at the source server locally.

    There are two options to resolve the issue

    1) increase the timeout values to mask the problem or

    2) improve the query performance so it won't take that much time

    I prefer option 2. 😉


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply