CUSTOM SCRIPT: LP_M2_INACTIVATE_PATRONS

This script is meant to run as a nightly routine. 

The purpose of the script is to find any patrons that have had the "E-Marketing Restriction" on the general tab, or have been marked as "deceased" on the general tab in the last 24 hours, and globally unsubscribe their primary email address (the address noted on the general tab.)

This script also depends on using LP_M2_HTTP_REQUEST, and may require additional setup. Please email mail2@lynch2.com if you need further assistance. 

This procedure is not able to be used by consortia because it is meant to be used with data found on the General Tab that is not control grouped. 

Enjoy!

LP_M2_INACTIVATE_PATRONS.sql

Still need help? Contact Us Contact Us