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.
Hi Mindee et al!
I have written utilities for our consortium to change list and scheduled report owners, as well as a backend script that alerts us if any scheduled reports failed or will fail (because of the inactive credentials, etc.). I'm happy to share those scripts, and I can send cleaned up versions (for v15) out to TN to put on TASK. Since that may take time, though, I'm happy to send out less clean versions to you (and anyone else who's interested) directly, just DM me. When you do, let me know what version you're on, as some of the report table structures have changed between v14 and v15.
And that doesn't totally answer your question about updating those failing reports en masse, but my scripts should point you in the right direction for that.