My basic question is; can I use trans SQL to check to see if a cube is being processed? i.e. is there a processing flag in a table somewhere?
My full problem is that I have 2 cubes. They are built in 2 SSIS (DTS) packages. The packages run a batch of data refresh processes before building the cube and are staggered so the cubes shouldnt really be built at the same time. However, i'd like to put in a process that checks to see if the other cube is being processed before it starts processing its own cube.
If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.