Forum Discussion
Helper IScheduled Refresh - hourly for only certain days
Naverie wrote:
Surely this does the exact same thing? Just means I have one for each month instead of one for each hour?
No, It's not exactly the same. With this approach you would need to either create a new "september" schedule every year or manually edit this schedule every year. If you forget the model will not be refreshed. With the approach I suggested, once it works for the first month it should continue to work forever until it is switched off. So it might take a few more minutes to setup the approach I suggested initially, but then you should not need to touch it again.
Super UserI don't think you can do this in a single schedule. You could create a set of monthly refreshes that only run on days 1-4 but I think you would need to create a separate schedule for 9am, 10am, 11am etc but if it is only business hours you might only need to create 8 or 9 of these.
