How to automatic process SSAS cube using SQL Server agent job

smith88

How to automatic process SSAS cube using SQL Server agentjob
After connecting to the Analysis Server, right click onthe Cube and select Process

When the process window opens, click the dropdown by Script andselect Script Action toClipboard. Then click Cancel so youwill not start processing the Cube immediately.

Now open a job or create a new Job in SQL Server agent.

　　In the Jobwindow, 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 ServicesCommand. Enter the Server and Paste the contents of the Clipboard from earlierinto the Command window.

　　Click OKtwice and the Job will now include the step to execute the pasted script whichwill process the Cube.
In the Job window, click on Schedules, then you canschedule you SSAS cube process job.

Dive for more about automatic process SSAS cube using SQLServer agent job
　　You may have errors using SQL Server Jobfor your remote SSAS cube server,
　　Create Proxy account for Job processing
　　1, Create credentials

　　2 create new proxy account for cube processjob

　　After that you can create a new job forremote SSAS cube server in your local server agent if you add your credentialsas admin for your remote SSAS cube server