Job scheduler to process the SSAS Cube or SSIS Package to execute the cube

At present, we are doing manual steps to process a cube. We do it on daily basis. I am trying to create a Job Scheduler from SQL Agent to process the Cube on every morning by 9:00 AM. Prior to process the cube, I wonder what would be the best bet to automate the Cube Process.

Is there any ways to call the cube from SSIS Package and process it
chokkaStudentAsked:
Who is Participating?
 
lcohanDatabase AnalystCommented:
Please have a look at details from link below and after you create the package you may need to Execute it as the same NT account used for the package not under the default SQL Agent Service startup account to make sure is not failing on permissions/rights in SSAS.

https://bennyaustin.wordpress.com/2013/08/19/processcube/
0
 
chokkaStudentAuthor Commented:
Thanks !! Link is useful
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.