September 10, 2007 at 8:01 pm
Hi ,
I am using sql server 2000. One job is shedule for every weekend to process the cube. Problem is, cube process has been successful and i am able to see data in cube but if i running the job, i am getting message job is running.
Please any one will help how i can see that cube is still running or not.
September 12, 2007 at 8:17 am
What kind of job is running the cube? Did you schedule a DTS Package with an Analysis Services Processing Task? If so, what method are you using to process the cube? (Process Database, Refresh Data, Incremental, Full Process, etc)
If you are using a DTS Package, I suggest you turn on Logging for that Package so you can tell what has run and what has not.
Here are a couple ways to tell if a cube is still processing.
1. Log onto the server that has Analysis Services on it and look at task manager to see how much CPU is being utilized by msmdsrv.exe. Keep an eye on it for a few minutes. Obviously if someone queries a cube, the processor will be hit, but if a cube is being processed, utilitization will be pretty high.
2. Check the date/time on the cube files... Browse to the Microsoft SQL Server Analysis Services folder in Program files (on the server) and look in the Data folder. You will see a folder there for every MSAS database. Look inside the appropriate folder and then you will see a folder for each cube. Look at the dates to see if one of the cubes have a date from a previous processing time, or if they all seem in line for when you started processing.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply