SSIS 包 - 执行超时错误 [英] SSIS Package - Execution Timed Out error

问题描述

我有数十个 SSIS 包按各种计划执行，所有这些都通过 SQL 代理进行控制.有时我会注意到某项工作没有按常规计划解雇，我会检查该工作的历史记录.然后我会注意到最近的作业执行失败，并显示一条错误消息:描述:操作失败，因为执行超时..."

I have dozens of SSIS packages being executed on various schedules, all controlled via the SQL Agent. Sometimes I'll notice a job hasn't fired on its regular schedule and I'll check the History of the job. I'll then notice that recent executions of the job have failed with an error message that says, "Description: The operation failed because the execution timed out..."

我很确定这与 SSIS 包内的实际代码无关，因为我设置了一个错误事件处理程序，并且包本身从未产生错误.我会知道这一点，因为我设置了事件处理程序，可以就任何类型的错误向我发送电子邮件.我没有收到来自这些包裹的任何电子邮件.

I'm pretty certain that this is not related to the actual code inside the SSIS package because I have an error event handler set up, and an error is never generated from within the package itself. I would know this because I have the event handler set up to send me an email on any sort of error. I am not getting any emails from these packages.

我唯一看到的是显示此超时错误的历史记录.所以，我的问题是这个.究竟什么是超时，为什么?

The only thing I see is the History showing this timed out error. So, my question is this. What exactly is timing out, and why?

推荐答案

您可以在 SQL AGENT JOB 中再添加一个步骤，以便在打包作业步骤失败时发送警报.

You can add one more step in SQL AGENT JOB to sent a alert when package job step failed.

打开SQL Server 代理作业，然后转到编辑>高级>失败操作选择警报步骤.如果超时，您应该检查 tempDB 数据文件 中的空间，如果空间可用，则可能当时有很多作业正在运行，因此请更改作业的时间.如果 tempDB 中没有可用空间，则必须在 datafile 中创建一些空间以避免 SQL Server 中的超时.

Open SQL Server Agent Job and then go to Edit>Advance>on failure action select alert step. For time out you should check the space in tempDB datafile, if space is available then it might be there were lots of job running at that time ,so change the timing of the job. If Space is not available in tempDB then you have to create some space in datafile to avoid the time out in SQL Server .

对于缩小数据库，清除缓存请运行下面的脚本.

For shrink the database ,clear the cache please run below script.

Use [tempDB]
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
CHECKPOINT;
DBCC SHRINKFILE(yourdb_log, 200);

这篇关于SSIS 包 - 执行超时错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！