locked
Determine status of processing cube RRS feed

  • Question

  • From C# I need to determine if a cube is currently processing.  We are trying to avoid running MDX against a cube while in the act - it results in an error message to our users.

    Does anybody know of a way to do this?  Maybe with AMO?

    Thanks in advance,

    John

    Wednesday, October 4, 2006 6:05 PM

Answers

  •  

    Hello John,

    There is no easy way of doing this in AMO, but you could use the DISCOVER_LOCKS schema rowset to test whether there are write locks on your cube. The LOCK_STATUS and LOCK_TYPE fields returned by this discover could help you find this out.

    Hope this helps,

    Artur

     

    Wednesday, October 4, 2006 8:55 PM