Scheduled Refresh - hourly for only certain days

[Naverie]

Hi,

We have a report that the Finance department use and they would like it to refresh hourly but only for the 1st 4 days of each month.

Is this possible to do? I've tried but can't see an option to do so.

Thanks in advanced.

[d_gosbell]

No, you would set up 8 or 9 schedules to look like the following just changing the start time for each one to the hour of the day that you want the refresh to happen.

[Naverie]

Surely this does the exact same thing? Just means I have one for each month instead of one for each hour?

[d_gosbell · Accepted solution]

---

@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. 

[d_gosbell]

I 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.

[Naverie]

@d_gosbell I didn't think it would be.

Looking at it, to do what you said I would need to create one for every month of the year with start and end dates? 

That seems to be the only feasible option as the Month schedule will only let you run it once.