Set a job to process a Cub

Question

Set a job to process a Cub

cafc

SSCommitted

Points: 1647
More actions
February 3, 2010 at 10:03 am

#210513

Hi,
Can anyone explain how I can set a job to process my Cube (SSAS) on sql server 2008?
Thanks in advance.
Cafc

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 1

I have not done in SQL Server 2000, but had performed this in SQL Server 2005 / 2008. In both these versions I had choice to use the SSIS and carry out the task or script the cube processing task and create a Job step of SSAS task and use that script..

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

cafc SSCommitted Points: 1647 More actions · Answer 2

thanks for your answer, but its not possible to add a job to the SQL Server Agent (under Microsoft Sql Server Management Studio) and then add a step to process the cube and then set some daily basis schedule?

What I really don't know is which type (on step window) that i have to chose?

is necessary to make some query to perform the process of cube?

thanks

cafc

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 3

I don't have an SSAS Cube in SQL 2000 currently, so I can't try it and reply. But I would suggest you to take a look at performing it from SSIS package, if you have SQL 2005 or above. (again I have not tried this, but it should be a workaround)

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

cafc SSCommitted Points: 1647 More actions · Answer 4

Hi again,

I think you didn't understand my question! first I using the sql server 2008 (as said before) and not sql server 2000! and second the solution for this easy problem is here:

http://sqlblogcasts.com/blogs/davidwimbush/archive/2009/11/25/how-to-process-a-cube-in-a-sql-agent-job.aspx

But thank you anyway.

cafc

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 5

cafc (2/4/2010)
Hi again,
I think you didn't understand my question! first I using the sql server 2008 (as said before) and not sql server 2000! and second the solution for this easy problem is here:
http://sqlblogcasts.com/blogs/davidwimbush/archive/2009/11/25/how-to-process-a-cube-in-a-sql-agent-job.aspx
But thank you anyway.
cafc

I some how didn't see the 2008 yesterday. I saw the post in SQL Server 7,2000 section and that's why I assumed it to be 2000. I see the post is edited, so I can't argue now..

What if I go and edit my yesterday's reply and remove the SQL Server 2000 part? ( I wouldn't do that)

But welcome anyway..

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty