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.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.