作为代理作业运行时作业失败 [英] Job Failed when run as an Agent Job

问题描述

大家好，

我创建了一个包，这些都是详细信息。

I created a package and these are the details.

1）在SERVER A上创建了包。

1) Created package on SERVER A.

2）涉及3个数据库（服务器A上有2个，服务器B上有1个）

2) Involved 3 databases (2 on Server A and 1 on Server B)

没有加载问题和数据的包已执行。包部署状态成功..所以我继续创建了一个SQL Server代理作业。当我执行这个工作时，它失败了。我可以访问服务器和数据库，我收到错误：

Package executed w/o issues and data loaded. Package deployed state success.. So i went ahead and created a SQL Server Agent Job. When i execute this job it fails. I have access to both the servers and databases , i get the error:

用户登录失败"WAB \ WABSQLATF $"

Login failed for the user "WAB\WABSQLATF$"

我使用我的凭据创建了作业，为什么错误消息在消息中显示某种系统用户？任何建议都表示赞赏。

I created the job using my credentials, why is the error message showing some kind of system user in the message? Any advice is appreciated.

谢谢

推荐答案

使用代理帐户运行ssis软件包

use proxy account to run ssis packages

这篇关于作为代理作业运行时作业失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！