dbTalk Databases Forums  

How can I program automatic processing of Cubes Execution?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss How can I program automatic processing of Cubes Execution? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Nela Gregori
 
Posts: n/a

Default How can I program automatic processing of Cubes Execution? - 06-12-2006 , 04:22 AM






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?

Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: How can I program automatic processing of Cubes Execution? - 06-12-2006 , 06:45 AM






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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.