How to Automatic process SSAS cube using SQL Server Agent job

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 ScriptAndselect Script Action Toclipboard. Then click CancelSo 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 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 would now include the step to execute the pasted script Whichwill process the Cube.

in the Job window, click on schedules and then you canschedule your 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 SQL Server Agent job

You could have errors using SQL Server jobfor your remote for 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 the can create a new job Forremote SSAS Cube server in your local server Agent if you add your Credentialsas ad Min 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 "/>

This article from "Proud Snow Star scar" blog, declined reprint!

How to Automatic process SSAS cube using SQL Server Agent job