Report subscriptions running on incorrect schedule after database move

[laridae]

We have found that if we move the database to a different server that reports that are scheduled to run every 2 weeks will run on the incorrect week (not all of them, just some of them).

This can be corrected by editing the subscription, edit the schedule, then clicking apply, click apply.

Can this please be fixed or can this action be done programatically?

We are running on an AG so a "database move" may happen at failover.

[d_gosbell]

I'm pretty sure it's safe to say that this should not happen. But it's hard to say whether it's a bug or a configuration issue. Your best course of action would be to raise an official support ticket with Microsoft so that a support engineer can investigate this with you.