SQL Server 2005 服务代理停止调用过程
我有一个服务代理(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 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论