i want to create a web application with JAVA EE in order to monitor Tivoli Storage Manager which is an entreprise solution for storage management and backup data.So what i want to do exactly is to build service/script/scheduled job/timer to run SQL queries in background from TSM server database and extract the result into another database created locally MYSQL for example. So what is the proper way to do that ?
Thanks for your help in advance,