The powers at be have decided that they would like to automatically run a trace on one of our analysis servers when it processes a cube in the early hours of the morning. Now I have no problem creating a SQL Profile to run and store the results in a database table for them, but I have no idea how to automate it so that it runs everyday, any help would be greatly appreciated.

SQL 2005 contains a utility called SQLDIAG. It has the ability start and stop given specific date time information. You can also collect Windows perf, event logs, and a nice blocking script that will record blocking over time. SQLDIAG replaced PSSDIAG, that was geared toward previous versions. The BOL contains basic information on the utility. WARNING: SQLDIAG has the ability to collect massive amounts of information that can degrade performance. Make sure you collect as little as necessary to diagnose the issue.

Adam Gossage
Lake Wylie, SC, USA