Hello,
Due to some of maintenance activity, we often require to recycle the SSAS service so I am thinking of automating the recycle using PowerShell script however I couldn't figure out a way to check on when the SSAS is back online (after service is up, it takes some more time for cubes to come online as it loads into memory).
I was initially hoping to run a DMVs constantly until successful connection establishes but trying to see if I can get any better ideas from folks here.
Thanks