Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 analysis service

Author  Topic 

Zul
Starting Member

17 Posts

Posted - 2009-08-14 : 05:51:31
Hi All
can you show me how can i run outomatic process in analysis service in sql 2005?

thanks

Zul

X002548
Not Just a Number

15586 Posts

Posted - 2009-08-14 : 22:38:33
Do you mean you want to have a schedule process run at a schedule time, or every so many minutes? Or off an event that occurs?

There is no Dana..there is only Zul

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-08-15 : 03:08:17
seems like what you're asking is to schedule a job in sql server which does processing of cube. you can do this by creating a ssis package with process cube task and calling it from scheduled job
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-08-15 : 03:09:45
see this also

http://www.dotnetspider.com/resources/24960-How-Process-SSAS-Cubes-Automatically.aspx
Go to Top of Page
   

- Advertisement -