In article <E4AFBC5E-F112-4C15-BAC2-A398E2BA9700 (AT) microsoft (DOT) com>, =?Utf-
8?B?TmVsYSBHcmVnb3Jp?= <Nela Gregori (AT) discussions (DOT) microsoft.com> says...
Quote:
In SQL Server 2000 it was possible to program the times you want to execute
the cube, and manage it by the Agent SQL Server.
How can I do this in SQL Server 2005? |
You can do the same thing in AS2k5, you would set up an SSIS package
with a AS processing task and then schedule that package using SQL
Agent.
If you have the Enterprise Edition of AS2k5 you can also look into the
proactive caching feature which can initiate processing on a timed or
notification basis.
--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell