Now that scheduled reports no longer run for schedule owners whose credentials are inactive, I could use some code to do updates on the back end in SSMS. Does anyone have an Update statement they're willing to share, or shall I just open a RAMP ticket?
While I'm thinking about it, I really wish that the "Manager" designation allowed that user to view/maintain the schedules created by anyone in groups she/he manages.
In 15.1, as a non-admin you'll be able to change the Owner of a report schedule if it is currently owned by you to any other user that has the same control group rights assigned to the schedule. As an admin, since they can see all report schedules, they can change owners on any report schedule, provided the user has rights to the schedule's control group.
I saw that little bit last week and got so excited. I know...it's the little things right.