• anusql74 - Monday, April 16, 2018 12:06 PM

    yes there is link server on all servers
    Job history is simply saying Success but table ' [SQL1].[Databasename].[dbo].[sqlversion_anu] is not updating the result from both servers SQL2 and SQL3

    okay, let's take this step by step.
    1.) Why use nvarchar(max) for a server name?   That isn't likely to be anywhere near 100 characters, much less 2 billion (max size of the max version of varchar or nvarchar).  This is wasteful.
    2.) You'll need to verify that none of these job steps are trying to run on one server, but select from another.
    3.) What's the true objective here?   Server names are usually static.   Why not just build a table of them and be done with it?
    4.) Check your execution context for each job and be sure that it has the necessary permissions to run any kind of query on each other server involved for that job step.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)