Browse by Tags

SQL Agent and SSAS Commands
30 May 2011 15:27

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... Read More...

by ACALVETT | with no comments

Filed under: Tips, SSAS 2005, Analysis Services, SSAS, 2008, Locking, SSAS 2008 R2, 2008 R2, Blocking, Default Database, Processing, SQL Agent