Job On Sql Server Agent 未完成，但在 BIDS 中完成? [英] Job On Sql Server Agent does not complete, but it does in BIDS?

问题描述

我的程序包在 SSIS (BIDS) 中就像一种享受，并在 4 分钟内执行.登录到 SQL Server 管理工作室中的集成服务并将其导入到文件系统或存储的包中，然后运行它，同样需要 6 分钟.

My package works like a treat in SSIS ( BIDS ) and executes in 4 minutes . Logging onto integrations services in SQL Server management studio and importing it into file system or stored packages and then running it, again takes 6 minutes .

现在将其移至 SQL Server 代理.它运行并运行.... 看起来当涉及到一些任务时，这意味着运行一个 bat 文件来打开一个 excel 文件然后一个 vbs 文件来运行一些宏，它似乎无法应付它.我使用 sql server profiler 解决了这个问题.40 分钟后终止了工作并且没有有意义的错误.甚至查看了 Windows NT 日志！

Now moving it to SQL Server Agent . It runs and runs .... Looks like when it comes to a few tasks that mean running a bat file to open an excel file then a vbs file to run a few macros it seems it cannot cope with it . I worked this out using sql server profiler . Killed the job after 40 mins and no meaningful errors . Even looked at the Windows NT logs !

我需要让这个程序包在 sql server 代理上运行，以便它是自动化的，我可以安排它每天运行几次.

I need to get this package working on sql server agent so it is automated and I can schedule it to run a few times every day .

有人可以帮我解决这个问题吗?

Can anyone help me resolve this as I am stuck ?

SQL Server 用户/凭据/代理帐户已正确设置，并且在控制流的早期它确实运行了另一个 bat 文件，该文件将一个文件复制到另一个目录.

SQL Server User / Credentials / proxy Account has been set up correctly and earlier in the control flow it does run another bat file which copies across a file to another directory .

推荐答案

这是因为 SQL Server 代理不会加载用户的环境来运行 Excel 宏.您需要通过 Windows 计划程序安排 Excel 宏(并至少登录一次以清除出现的 Excel 许可小弹出窗口).

This is because SQL Server Agent does not load a user's environment to be able to run Excel macros. You need to schedule Excel macros via the Windows Scheduler (and log in at least once to clear the Excel licensing little pop-ups that come up).

这篇关于Job On Sql Server Agent 未完成，但在 BIDS 中完成?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！