June 4, 2015 at 1:29 am
Hi All,
I need to know how can I check from Database if a Cube has been processed today or not?
When a cube processing is done, all it does is a Select Query on the DataMart and then updates to the Cube to Sync it with the underlying Database.
What I additionally want to know is that when the processing completes, can this event(of successful processing done) be captured from, say Database? Does such an event exist at first place which would update some table etc
June 4, 2015 at 1:36 am
You can use the ASSP project GetCubeLastProcessedDate function to get the last time a cube was processed:
http://asstoredprocedures.codeplex.com/wikipage?title=CubeInfo&referringTitle=Home
You could query this from your database using OpenQuery from your DB.
Alternatively if you have the process being done by SSIS or a SQL Agent job then you could add a control flow item/job step to update a logging table when the processing is finished.
June 4, 2015 at 2:25 am
Hi PB,
While I am not sure of the first solution that you have proposed, as assembly needs to be registered and that might not go very well with DBAs. However, that is very much what I wanted and I would keep this in mind for future.
The second part, of using a T-SQL as one of the steps in SQL Agent Job to update a Table sounds very good and I have to admit it was lame of me not think of that one.
Simple and Effective.
Based on the Success status of Cube Processing Step (in my SQL Agent Job) we can execute the Update statement and thus have a flag which is set ONLY when the Cube Processing is Successful else the T-SQL step won't execute at all.
Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply