How to automatic process SSAS cube using SQL Server agent job

標籤：process   sql   ssas   agent   cube   

How to automatic process SSAS cube using SQL Server agentjob

 

After connecting to the Analysis Server, right click onthe Cube and select Process

 

650) this.width=650;" width="554" height="368" title="1.png" src="http://s5.51cto.com/wyfs02/M02/88/6C/wKioL1f3dlGQXfUWAAB3AuXTNEE722.png-wh_500x0-wm_3-wmp_4-s_522582957.png" alt="wKioL1f3dlGQXfUWAAB3AuXTNEE722.png-wh_50" />

 

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.

650) this.width=650;" width="554" height="497" title="2.png" src="http://s3.51cto.com/wyfs02/M00/88/6D/wKioL1f3dmXAQ1MZAADIXrvWo-U159.png-wh_500x0-wm_3-wmp_4-s_781873223.png" alt="wKioL1f3dmXAQ1MZAADIXrvWo-U159.png-wh_50" />

 

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

650) this.width=650;" width="491" height="258" title="3.png" alt="New Job" src="http://s3.51cto.com/wyfs02/M02/88/6D/wKioL1f3dnWzhrbbAABRnY114ng120.png-wh_500x0-wm_3-wmp_4-s_434908588.png" />

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.

650) this.width=650;" width="553" height="376" title="4.png" src="http://s1.51cto.com/wyfs02/M01/88/70/wKiom1f3dofyszFcAAE_BWczjxk837.png-wh_500x0-wm_3-wmp_4-s_4040760723.png" alt="wKiom1f3dofyszFcAAE_BWczjxk837.png-wh_50" />

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.

650) this.width=650;" width="554" height="446" title="5.png" src="http://s5.51cto.com/wyfs02/M02/88/70/wKiom1f3dpWwKYRTAADX3-UMH6g644.png-wh_500x0-wm_3-wmp_4-s_2276940365.png" alt="wKiom1f3dpWwKYRTAADX3-UMH6g644.png-wh_50" />

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

650) this.width=650;" width="554" height="205" title="6.png" src="http://s1.51cto.com/wyfs02/M00/88/70/wKiom1f3dtDhUZyLAACj79eL7Ko784.png-wh_500x0-wm_3-wmp_4-s_3281260629.png" alt="wKiom1f3dtDhUZyLAACj79eL7Ko784.png-wh_50" />

2 create new proxy account for cube processjob

650) this.width=650;" width="482" height="247" title="7.png" src="http://s2.51cto.com/wyfs02/M02/88/6D/wKioL1f3dt7DWMqAAAA5ZGlQnbQ232.png-wh_500x0-wm_3-wmp_4-s_827155167.png" alt="wKioL1f3dt7DWMqAAAA5ZGlQnbQ232.png-wh_50" />

 

650) this.width=650;" width="554" height="497" title="8.png" src="http://s3.51cto.com/wyfs02/M01/88/70/wKiom1f3dvWj3tScAACYGbHXJSU360.png-wh_500x0-wm_3-wmp_4-s_335108493.png" alt="wKiom1f3dvWj3tScAACYGbHXJSU360.png-wh_50" />

 

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

650) this.width=650;" width="554" height="497" title="9.png" src="http://s1.51cto.com/wyfs02/M00/88/6D/wKioL1f3dwKwEW_6AAF0bOYz2J0320.png-wh_500x0-wm_3-wmp_4-s_4123035082.png" alt="wKioL1f3dwKwEW_6AAF0bOYz2J0320.png-wh_50" />

本文出自 “傲雪星痕” 部落格，謝絕轉載！

How to automatic process SSAS cube using SQL Server agent job