数据库JOB执行失败。。
报错信息为:
Executed as user: AP\SA-JJMCSQLSRVAGENT. The OLE DB provider "SQLNCLI10" for linked server "10.192.80.128,11433" reported an error. Execution terminated by the provider because a resource limit was reached. [SQLSTATE 42000] (Error 7399) Cannot fetch the rowset from OLE DB provider "SQLNCLI10" for linked server "10.192.80.128,11433". . [SQLSTATE 42000] (Error 7421). The step failed.
上网查了下,是执行超时的问题,网上查了他们说要修改超时设置,那设置这个超时值我是在linked server上面设置还是job本地设置?