SSAS trace - SQLProfiler - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

SSAS trace - SQLProfiler

Author

Topic

ramaiah
Starting Member

27 Posts

Posted - 2010-03-25 : 22:35:25

I want to schedule a trace(not database engine,for SSAS), but SQL Profiler does not have a built-in scheduling option. So how do you use SQL Agent to schedule a SQL Profiler trace(using any stored procedure like sp_trace_create)?

Thanks
Ramaiah.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-25 : 23:17:52

SQL Profiler allows you to script out the trace so that it can be scheduled as a job.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

ramaiah
Starting Member

27 Posts

Posted - 2010-03-28 : 22:05:44

Thanks for reply.

When i am using database engine, i can able to take the script file out but for SSAS profiler not generating script file its generating the .xmla file.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources