Reprocess SSAS tabular cube after failure

Question

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.

Is there a way to do that in SSAS Tabular?

Answer 1

Nothing built into SSAS will automatically restart processing on error.

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.