失败后重新处理 SSAS 表格立方体 [英] Reprocess SSAS tabular cube after failure

问题描述

因此，我们每天晚上处理 SSAS 表格立方体，而前一天晚上，立方体的处理失败了.现在我想做的是实现一个在失败后触发自动重新处理的系统.

So we process the SSAS tabular cubes every night and the other night the processing of the cube failed. Now what I want to do is implement a system that would trigger an automatic reprocess after failure.

有没有办法在 SSAS 表格中做到这一点?

Is there a way to do that in SSAS Tabular?

推荐答案

SSAS 中的任何内容都不会在出错时自动重新启动处理.

Nothing built into SSAS will automatically restart processing on error.

在 SQL 代理中，作业步骤属性"对话框有一个带有重试尝试属性的高级选项卡.如果您将其更改为 1，那么它会在失败时自动重试该步骤(SSIS 包).

In SQL Agent, the Job Step Properties dialog has an Advanced tab with a Retry Attempts property. If you change that to 1, then it will automatically retry the step (the SSIS package) if it fails.

这篇关于失败后重新处理 SSAS 表格立方体的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！