Kathleen -
Thanks for giving Jill Z a heads-up about this. We upgraded this week, and I reanimated your old account until tonight when I had time to change the users in gooesoft_request.
Clarke
Hi All,
I'm taking over from a predecessor Tessitura admin who associated all of the important reports (Member Update Utility, Billing, Attribute Maintenance, "etc, etc, etc, and so forth"...) with their personal login account in Tessitura. So at some unknown date in the not-so-distant future, this account's password is going to expire because it has not been re-set. Or I'm going to come along and inactivate this account. And these business processes will come to a halt.
In the past, I would create an API account for these must-run reports. Set its password to something long and crazy and its expiration date way in the future through SQL on the backend. And then Associate important reports/utilities that just have to run with the captive report running account.
Going way back when the report server was less reliable. I knew a DBA who decided to make a SQL Server Job out of each of these must-run reports/utilities. The challenge with this is as an organization changes its Tessitura Admin / DBA over time. Finding these "must-run" reports get to be a challenge. And one is concerned about locking down a past admin account for the fear of breaking these critical business functions.
I'm looking for community best practices on this point before making changes at my current organization.
How do you run those "reports/utilities" that just have to run? Why do you do it that way? What will happen to your organization when you are no longer around to supervise the process?