Hi All,
We created a job which check the metadata changes on registered tables in each version of projects and send a detailed email.
Basically, it pulls all the registered tables ine each version and check whether any changes has been made or not on registered tables. Such as, new or deleted columns, column length/type, Indexes, Foreign Keys, Primary Keys etc.
That bewares TDM Admins with metadata changes daily before executing jobs like Data Subsetting, Data Generation etc. So, they can easily eleminate any errors on TDM Portal jobs which are provided as Self-Service Data Provisioning Jobs.
This job can be trigger for specific project through TDM Portal or can be scheduled for a time frame for all projects.
Below you may find some screenshots about the process.
1. Service Offering to Check Conflicts
2. Sent Email after Job Execution
------------------------------
Managing Consultant
GUNITTECH
------------------------------