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.
| Author |
Topic |
|
bhushan_juare
Starting Member
45 Posts |
 Posted - 2011-09-29 : 10:10:55
|
| Hi Guys,I want to know how to Schedule SSAS Cube, I have tried below steps but got stucked at step no 6Steps to Create SSIS And Schedule It...1. Create a New Integration Service Project. In the control flow tab, add a connection manager for analysis Services database and refer the instance of analysis service database in which cube exist.2. From the Control Flow tool bar tab, find the ‘Analysis Services Processing Task’ and drag and drop to the control flow panel.3. Edit this task and add the ‘cubes’ which we want to process in the object list option4. Build the project and In the file menu, select ‘Save…..as’ and save the package to Analysis Services Database Server5. Connect the Database Engine using Management Studio6. Go to SQL Server Agent and Right Click on the Jobs. Add a new Job and set the Job Type as ‘integration Service’.7. And Select the locally saved SSIS Package and set the period option as per your requirement8. That’s it. Now the cubes will be processed at the scheduled intervals. if anyone knows how to do this or any other ways to do this let me know.Thanks.. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-29 : 12:55:43
|
| why you got stuck at step 6? what happened when you created job? before that, did you try manually running package and see if it processed cube successfully?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
bhushan_juare
Starting Member
45 Posts |
Posted - 2011-09-30 : 01:04:10
|
| yaa, Package has been running sucessfully in Visual Studio 2005 Client as well as in Sql server BIDS 2005 But when I reached at steps 6, i got stucked while creating "New Job" in SQL Server Agent. In the new job page window I found options like Generals, Steps, Schedule, Alerts, Notifications and Agents from where mine actual problems get started. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-30 : 01:11:55
|
| those are the properties of job. do you mean you dont know how to set them? or is it that you're facing some issue trying to set values for properties?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
bhushan_juare
Starting Member
45 Posts |
Posted - 2011-10-01 : 01:37:52
|
| When cube get scheduled using "SSAS processing task" in SSIS how will I came to know its upadating the new records in SSAS DatabaseIs their something in "SSAS processing task" to know this? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-01 : 12:36:02
|
| there's no concept of records in SSAS db. it should be dimensions,measure groups and partitions. Have you added logging for SSAS processing?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
SSAS Cube Schedulling?