开发者

SSIS package is not terminating

I have a SSIS package which will execute a set of sql commands and some sps. there is one main sp in the pac开发者_开发知识库kage which will execute some sps in loop. But when i scheduled it as job in sql server, sps will be executed but it never comes out from the execution. It will stuck in that satage.


I would do some serious debugging here. It sounds like one of your stored procs either

1) has an endless loop somewhere or 2) there is a significant amount of blocking happening

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜