• i have a job on my server which takes data from linked server which generally takes 10-15 mins but

    from past few days it takes 1 hour to complete or the job fails giving the below error

    Message

    Executed as user: NT AUTHORITY\SYSTEM. Cannot fetch a row from OLE DB provider "SQLNCLI" for linked server "MYSERVER". [SQLSTATE 42000] (Error 7330) OLE DB provider "SQLNCLI" for linked server "MYSERVER" returned message "Query timeout expired". [SQLSTATE 01000] (Error 7412). The step failed.