Hello,
What version of TCRM are you using. There were some enhancements added in version 5.1 that should help automate what you want to do. Before TCRM 5.1, in order to pick up certain metadata changes, all Middle Tiers would have to be shut down and the buffers deleted. Now with 5.1 and later, the offline Middle Tier components are designed to refresh any outdated buffers automatically when necessary. As a result, metadata changes (such as modifying a legend) can be used immediately.

Also, what part of the process do you want automated? Once a legend change is made in TCRM Metadata, in version 5.1 TCRM metadata automatically updates the middle tier buffers. So, whenever a TCRM client logs into the application, they get the latest set of legends. Is this the part you want automated or are you referring to some other part of the process?
thanks,
Carol

Hello Robby,
Asked some of our CRM SME's to get you an answer. Here is what they came back with.

There is no facility to automatically update a legend range value after it has been changed in a table/view. However, it could be accomplished through some relatively straightforward customization that would utilize the Windows Scheduler to run a process written to let TCRM know that tables containing the legend range value(s) that have been changed. The Teradata CRM application needs to know that some of the legend details have changed and that the next time a user (client PC) accesses these records, there may be a need to re-buffer the data. To do this, the Table Alias records (IOS_TBL_ALIAS table) need to be updated for the tables impacted which could be accomplished using a custom written script run in an automated fashion using the Windows Scheduler. This will update the tables in Teradata CRM so that they will be buffered again as needed.

Let me know if this answers it for you.
Thanks for your post!
Carol