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.
Any help would be much appreciated.