Is there any way to inactivate multiple lists at once? we have thousands of old lists that haven't been generated in a decade or more, and while I don't think it will cause too many disruptions if I mass delete them, I'm wondering if mass inactivating is an option, without having to go into each list's properties and inactivate them one at a time.
I use something pretty basic since we have naming conventions that begin with the FY making it easy. If you have a similar set up this would be an easy way to do it:
UPDATE T_LIST SET inactive = 'Y'WHERE list_desc like 'xxxx'
Other things I update like this:
list categories (replace X with the category number from TR_LIST_CATEGORY) category = 'X'
tms = 'N'
tstats (analytics) = 'N'