跨服务器访问的问题
了缘 2005-01-28 09:17:37 1,首先我建立了一个LINK,名称为LINK_132测试是成功的,可以查询出数据
2,在查询分析器中执行以下语句
INSERT INTO dbo.results1 (palnt,salesno,ln ,salesdate ,customercode,customername,customerarea,curr,
rate,item,qty,price,amount,txamount,model,type,size,person,personname,personarea,personarea1)
SELECT palnt,salesno,ln ,salesdate ,customercode,customername,customerarea,curr,
rate,item,qty,price,amount,txamount,model,type,size,person,personname,personarea,personarea1
FROM LINK_132.TEST.DBO.results1
也是成功的,
3,问题在于,我把上面的语句写在一个作业的第二步执行,作业总是运行不成功(第一步是成功的)
作业日志如下:
The job failed. The Job was invoked by User sa. The last step to run was step 2 (STEP2). The job was requested to start at step 1 (STEP1).
不知道是否和LINK有关系。?
请教各位,应该如何解决。谢谢!