I want to enable a trace on analysis services
Filter only the errors and notifications
log them in a table and send a mail.
I am right now doing using sql profiler, but i dont want to do this using profiler as i have to log on the server continuously.
I need to do this in T-sql like an SP or a job etc..
please let me know if there is a better solution to track and send an email on analysis services.(I have 100's of cubes, so i cant enable error configuration on each cube.)
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!