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.
| Author |
Topic |
|
dbthj
Posting Yak Master
143 Posts |
 Posted - 2011-01-28 : 15:03:32
|
| I sent an export of One of the Standard Reports (Performance - Top Queries by Average CPU Time) to an application admin. He loved it and wanted one created on a regular basis. Since they are kind of a packaged deal, it shouldn't be hard to create a job to get the report and export it somewhere, then email it daily. But is seems to be impossible. It's super-simple to do manually, but I sure don't see any way to automate it in a job. Anybody know how to do that? SQL 2008 on Windows 2008. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-28 : 15:33:09
|
| Reporting Services is a good idea for this, or you can custom build your own engine to generate 'em.You can pull up the Server Dashboard Report with profiler running to see the queries executed.Might have a look at this article as well. |
 |
|
|
|
|
|
Schedule Standard Reports