取消正在运行的 SQL Server Reporting Services 报表订阅?
我创建了一个 Reporting Services 报告并将其设置为在订阅上运行。 (SQL Server 2005,如果它有影响的话。)
不幸的是,看起来我在参数中犯了某种错误,并且它似乎已经停止,但它实际上并没有失败,只是坐在“0已处理”上”。
我想取消它来修复错误,但我不知道如何做。停止/重新启动服务似乎没有什么区别。
我需要做什么来阻止它?
I've created a Reporting Services report and set it to run on a subscription. (SQL Server 2005, if it makes a difference.)
Unfortunately, it looks like I've made some sort of error in the parameters, and it seems to have stalled, but it isn't actually failing, just sitting on "0 processed".
I want to cancel it to fix the error, but I can't figure out how. Stopping/restarting the services seems to make no difference.
What do I need to do to stop it?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
订阅是一项 SQL-Server 代理作业,并被赋予一个 GUID 作为标题。检查 SQL-Server 代理作业历史记录,如有必要,请停止该作业。
如果您有多个订阅,请检查此链接以获取有用的视图,了解哪些作业对应于哪个订阅。
http://www.sqlservercentral.com/Forums/Topic254010-150-1.aspx
A subscription is a SQL-Server Agent job, and is given a GUID as a title. Check the SQL-Server Agent job history, and if necessary stop the job.
If you have more than one subscription, check this link for a useful View on which jobs correspond to which subscription.
http://www.sqlservercentral.com/Forums/Topic254010-150-1.aspx