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.

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 (AT) hotmail (DOT) com> wrote

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 (AT) hotmail (DOT) com> wrote