my relational database is sql 2000,
and i would like to execute my new olap cubes that i have developed in as2005
can i execute it through a job?
what is my options

What do you mean by "execute" ? Do you mean process?
If so, there are many options available. You can:
- use the Analysis Services processing task in SSIS,

Script out the processing as a xmla script. Using SSMS, on the top of the
process partition dialog box has a button called "Script" -- click on it
rather than OK. That will give you the script in another window. Once you
have the script you can execute it as:
- a SQL Agent job (there is a new SQL Agent step type called Analysis
Services Command),
- use the Analysis Services Execute DDL task in SSIS

Lastly you could write a AMO application to do your processing.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Chai" <Chai (AT) discussions (DOT) microsoft.com> wrote