We're a five-organization in Kalamazoo that has been live since mid-2015 and we're about to have some high-level staff upheavals for the first time. One of my power users is leaving the consortium altogether, and another is switching organizations. I'd like to ensure that any scheduled reports set up by the user who is leaving completely will still continue to run.Have any other orgs dealt with this scenario?
Additionally, the leaving user has created a lot of custom reports for her org and I will need to make sure that "dbo" owns all of those. I would love some tips for best practices here, as well.
Thanks in advance!
Mindee
Excellent - thank you!
begin tran --commit tran
update a
set user_id = 'afuhrman'
from gooesoft_request a
join gooesoft_report_schedule b on a.id = b.request_id
join gooesoft_schedule_queue c on c.schedule_id = b.id
where user_id = 'dgibson' and c.computed_date > getdate()
BRIAN WILBUR GRUNDSTROM | Database Administrator SHAKESPEARE THEATRE COMPANY Recipient of the 2012 Regional Theatre Tony Award® 516 Eighth Street, SE | Washington, DC 20003-2834 p 202.547.3230 ext. 2216 | c 917.952.7957 bwg@shakespearetheatre.org www.shakespearetheatre.org www.brianwilbur.com Coming Soon: THE LOVER & THE COLLECTION – Artistic Director Michael Kahn serves up a double bill of Pinter plays, considering how we construct our own realities, which truths we tell and which lies we choose to believe. 2017|2018 SEASON • Pinter’s THE LOVER & THE COLLECTION • Shakespeare’s TWELFTH NIGHT • Shakespeare’s HAMLET • Raffo’s NOURA • Beckett’s WAITING FOR GODOT • Lerner & Loewe’s CAMELOT
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mindee Waltz Sent: Tuesday, September 12, 2017 11:40 AM To: Brian W. Grundstrom Subject: Re: [Tessitura Technical Forum] What happens to scheduled reports when a user leaves?
Brilliant - thank you for the quick responses!
From: Caryl Jones <bounce-caryljones3976@tessituranetwork.com> Sent: 9/12/2017 11:07:43 AM
As long as the date range for the schedule report has an end date far enough in teh future, they will continue to run even if you inactivate the user.
We have a process in place where our Box Office Administrator schedules all of our sales report and when they have left and we've had a new person in the role one we simply update the request table for the relevant reports in the database using SQL so that the new administrator owns the report and can then Maintain and make changes to the report schedule within Tessitura.
Caryl
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!