Report Portal

SQL Agent and SSAS Commands

SQL Agent can be used to execute SSAS commands such as processing of a dimension and i can see that it is useful when you want to quickly schedule an adhoc processing task but there is a major drawback you need to be aware of.

You are not able to specify the database to connect to and whilst you may think that it does not matter because the database is specified in the connection it really does matter. Below are extracts of a processing tasks from profiler which was executed using a SQLAgent task.


Tags: management, ssms, script


2007-2015 VidasSoft Systems Inc.