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!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: