维护计划中的链接服务器 [英] Linked server in a maintainance plan
本文介绍了维护计划中的链接服务器的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我创建了一个链接服务器名称(xyz),并在存储过程中使用它.它工作正常,但是当我在sql server管理的维护计划下添加此存储过程时,尝试执行该计划时在SQL Server代理日志中得到以下错误.
该任务由用户sa启动,以ituser执行.失败了.
我无法确定确切的错误,我想问题是sql服务器代理尝试使用链接服务器时,因为其他计划执行得很好.
Hi,
i have created a linked server name(xyz) and i am using it in a stored procedure.it is working fine,but when i add this stored procedure under the maintenance plan under management of sql server.When i try to execute this plan i get following error in sql server agent log.
The task was initiated by user sa,executed as ituser.and it was failed.
I am not able to figure the exact error,i guess issue is when sql server agent tries to use linked server,because other plan is executing well.
推荐答案
sql服务器代理作业的步骤属性,我选择了ssis包,因为它应该是t-sql语句.解决了啊!
in the step properties of sql server agent job,i had selected ssis package where as it should have been t-sql statement.solved ah!
这篇关于维护计划中的链接服务器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文