Have you ever faced the challenge of managing a large number of scheduled email reports at different times? Manually configuring and updating each subscription can be time-consuming and error-prone, especially when dealing with a high volume.
In my recent project, I encountered an issue: all emails scheduled for 19:00 had to be shifted to 19:15. Given the large number of affected emails, manually updating them in Microsoft Report Server seemed nearly impossible.
That’s when I decided to look for a smarter solution. By exploring the Microsoft Report Server (On-Premise) database, I discovered the Subscriptions table. This table stores all subscriptions, and it includes a column called [MatchData], where each subscription’s schedule settings are saved in XML format.
With just two lines of code, I was able to update all emails scheduled for 19:00 to 19:15! This approach not only saved time but also significantly improved accuracy.
Interestingly, by modifying the fields in this table, you can also perform other tasks, such as adding new email recipients to multiple subscriptions or updating their descriptions. This method provides exceptional flexibility in managing reports.
⚠ Important: Avoid adding new columns or rows to this table, as it may cause issues in the system.
If you’ve encountered similar challenges or have alternative solutions for managing subscriptions, I’d love to hear your thoughts—feel free to share them in the comments!