| Author |
How to schedule Analysis Service to Process Cubes and Demension Tables?
|
|
|
| How to schedule the Analysis Services to process the specific/all Cubes and
Demension Tables at the specific time and day? I search within the Analysis
Manager and I can not find any scheduling utility for it. Thanks.
| |
| Joel Leong 2005-08-28, 7:23 am |
| Create a Local Packages under SQL Server DTS in Enterprise Manager. You'll
find the yellow cube icon in SQL Server DTS, that is for Analysis Services.
After that, you can schedule the DTS package under SQL Server Agent - Jobs.
"Paul" <paul_mak@hotmail.com> wrote in message
news:%23E82Pd6qFHA.2592@TK2MSFTNGP09.phx.gbl...
> How to schedule the Analysis Services to process the specific/all Cubes
> and Demension Tables at the specific time and day? I search within the
> Analysis Manager and I can not find any scheduling utility for it. Thanks.
>
| |
|
| try the parrallelprocess utility.
this tool allow you to define what you want to process and you can use it
has in a batch file.
you can schedule it using the SQLAgent or any scheduling system.
"Paul" <paul_mak@hotmail.com> wrote in message
news:%23E82Pd6qFHA.2592@TK2MSFTNGP09.phx.gbl...
> How to schedule the Analysis Services to process the specific/all Cubes
> and Demension Tables at the specific time and day? I search within the
> Analysis Manager and I can not find any scheduling utility for it. Thanks.
>
|
|
|
|