posted 1/8/2011 by timmurphy - Views: [6232]
You may want to use SQL Server Agent to have a Cube processed as part of a scheduled job. This is how you create the step to process the Cube.
After connecting to the Analysis Server, right click on the Cube and select Process.
When the process window opens, click the dropdown by Script and select Script Action to Clipboard. Then click Cancel so you will not start processing the Cube immediately.
Now open a job or create a new Job in SQL Server agent.
In the Job window, click on Steps and New to open the New Job Step window. Give the step a name and change the Type to SQL Server Analysis Services Command. Enter the Server and Paste the contents of the Clipboard from earlier into the Command window.
Click OK twice and the Job will now include the step to execute the pasted script which will process the Cube.