维护计划中的链接服务器 [英] 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屋！