SQL Server 2005 服务代理停止调用过程

发布于 2025-01-02 05:44:10 字数 679 浏览 3 评论 0原文

我有一个服务代理(retention = OFF),它调用存储过程SP_dequeue

--Register SP for Dequeue operation
ALTER QUEUE [TEST_Queue] WITH RETENTION = OFF,ACTIVATION 
(      STATUS = ON,      
MAX_QUEUE_READERS = 1,      
PROCEDURE_NAME = sp_dequeue,      
EXECUTE AS owner
);

TRUSTWORTHY 并且启用了代理

SP_dequeue 基本上执行

RECEIVE TOP(1) from the TEST_Queue

并处理数据。几个月来它一直运行良好,但服务代理突然停止调用过程 SP_dequeue。但是当我选择队列时,我可以看到很多带有 STATUS = 1 的行,并且 sys.transmission_queue 为空。

到底是什么原因呢???当我检查事件日志时,没有错误或消息。在这之间机器被重新启动。重新启动后,队列也可以正常工作长达 2 周。请帮忙..

I have a service broker (retention = OFF ) which calls a stored procedure SP_dequeue.

--Register SP for Dequeue operation
ALTER QUEUE [TEST_Queue] WITH RETENTION = OFF,ACTIVATION 
(      STATUS = ON,      
MAX_QUEUE_READERS = 1,      
PROCEDURE_NAME = sp_dequeue,      
EXECUTE AS owner
);

TRUSTWORTHY and broker is enabled

SP_dequeue basically does a

RECEIVE TOP(1) from the TEST_Queue

and processes the data. It was running fine for months, but suddenly the service broker has stopped calling the procedure SP_dequeue. But when I select the queue I can see a lot of rows with STATUS = 1 and sys.transmission_queue is empty.

What all can be the reason ??? When I check the event log there is no error or message. In between machine was restarted. After restarting also the queue was working fine up to 2 weeks. Kindly help..

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文