0
I am a new into the project and we don't have any documentation. I have SQL Server DEV environment where I have numbers of databases. The source databases should refresh the analysis database after user will click "Refresh " button on the UI of the web application. What is a work around this process? How the database gets refresh? Is is done by SP, SSIS package or SQL Server Agent job, I couldn't find any scheduled job. I would appreciate any suggestions or thoughts how this process could be structured and where I can loon into to start trouble shooting this issue. Thanks
Welcome to SuperUser. Generally, reporting a problem requires that you tell us a problem. While you've given us some context and some general information, you have not actually describe a problem. Please note that we are not a Solution Provider. As in, we will not give you a plan for your entire DB refresh project. But if you are experiencing a problem, please use the EDIT button to make that more clear and give us more information, and we'll see what we can do to help you solve that problem. – music2myear – 2019-05-10T19:05:44.120