Post reply

Shedule a job

  • June 17, 2008 at 5:51 pm

    #188019

    How can i shedule a job where it process(full or partial) a particluar cube in my ssas project.

  • June 18, 2008 at 6:21 am

    #830337

    You can process a cube directly from the SQL Server Agent. Add a step of type "SQL Server Analysis Services Command" and enter a XMLA Query to process the cube. To get the XMLA query connect to your analysis server, point to the cube you want to process, right click and choose script object and there should be an option to generate the script to process the cube. Use that script in your job.

  • August 7, 2009 at 10:56 am

    #1036164

    This is exactly what I've been looking for, but I don't see that option under "script cube as...". I get options to create, alter, and delete; but not to process.

    How do I get that option to appear?

Viewing 3 posts - 1 through 2 (of 2 total)

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