Best practice for cube schedule enable?

Simple situation: we have a dev instance and prod instance. When creating cubes in dev, we create the schedule to build warehouse / in-memory but don’t enable it. The main reason is so that when deployed to prod, they don’t both run and overload the sql server.

So we leave the cube schedules disabled in dev.

But once deployed to prod, via export, that setting stays disabled. And it’s easy to forget to enable it, like was the case for us today. We updated a cube via export to prod, then went on to other things, forgetting that it won’t run.

What’s best practice here? Anyone have a good habit for getting this right?

1 Like