Can Tessitura have some sort of reminder to send to people when they forget to close the batch or maybe Tessitura has something like if you do not completely close the batch you cannot open a new one till you close the one that was opened before?
I have a SQL Agent job set to run every morning that does a combination of sending an email to each user with a list of their unclosed batches from days prior (using SQL Server Database Mail), and sending a message to a Slack channel.
Heath Wilder I am 1000% stealing that meme and adding it to my email notification. Perfect.
Here's my code if anyone wants to do this on their system. I don't know how much access to DatabaseMail you have on RAMP, but I'm sure it's possible to figure something out:
https://bitbucket.org/snippets/TN_WebShare/LrG4Eg
Thank you so much NIck. We will take a look at this SQL.