Schedule cube processing in SQL

Article:TECH193699  |  Created: 2012-07-25  |  Updated: 2012-08-24  |  Article URL http://www.symantec.com/docs/TECH193699
Article Type
Technical Solution

Product(s)

Issue



Cube processing works on the SQL server manually but fails to process on the Symantec Management Platform.


Error



There could be several errors observed or that the processing just does not complete in the symantec console.


Solution



 

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.
Process Cube
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.
  script
Now open a job or create a new Job in SQL Server agent.
New Job
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.
paste
Click OK twice and the Job will now include the step to execute the pasted script which will process the Cube.
Lastly choose schedule and set to run according to your preferences.

 




Article URL http://www.symantec.com/docs/TECH193699


Terms of use for this information are found in Legal Notices