待执行 [英] Pending execution

问题描述

从今天早上开始，我们的一项主要 SSIS 作业在执行时开始总是返回失败.当我们查看日志时，似乎所有的作业执行都堆在待执行"状态.

From this morning, one of our main SSIS jobs started to always return fail when executed. When we check in the log, it seems that all execution of the job stacked with the status "Pending execution."

我们使用的是这个 SQL Server 版本:

We are using this SQL Server version:

Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) 
Dec 28 2012 20:23:12 
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

我们已经尝试了几种方法，但现在没有想法了.

We have tried several things and are now out of ideas.

我们已阅读连接:http://connect.microsoft.com/SQLServer/feedback/details/629684/ssis-denali-need-a-way-to-recover-perpetually-pending-executions.

我们重新启动了 MSSQL 服务器，但仍然遇到同样的问题.

We restarted the MSSQL server and we still getting the same issue.

有没有人遇到过这种行为?如果是，你是怎么解决的?

Has anyone experienced this behavior before? If yes, how did you solve it?

谢谢，塞巴斯蒂安

推荐答案

我们与 Microsoft 开立了一个案例.解决方案是可能与网络上的 GPO 相关的安全问题.

We open a case with Microsoft. The solution was a security issue probably related to a GPO on the network.

我们重新分配以下用户的权限:

We reassign the user rights of:

- Act as part of the operating system
- Adjust memory quotas for a process 
- Bypass traverse checking 
- Log on as batch job
- Log on as a service 
- Replace a process-level token 

现在一切正常.

谢谢！

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