CUSTOM SCRIPT: LP_Mail2_inact_existing_addr

This custom script was submitted by the Simon Basyuk at Carnegie Hall. It is meant to run as a nightly job, which inactivates email addresses that are associated with both the mail2 default customer and a real customer in Tessitura. The script identifies that situation, and then inactivates the address associated with the default customer. 

mail2 does this action naturally, but not nightly. If your organization would like to have this action done nightly, on-demand, or on some other cadence, download and use this script for the job. 

If you are in a consortium, some adjustments may be necessary, but this gives you a good start. 

Thanks Simon!

lp_chc_Mail2_inact_existing_addr.sql

Still need help? Contact Us Contact Us