Script to find last time Cubes get processed | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Script to find last time Cubes get processed

Hi Guru, Where can I find OLAP tables Metadata? I want to query metadata to find out when was last time the cube ran? I schedule the cube to process every night. If the cube did not get processed then I’ll get e-mail. Please provide some tables where I can track down the last time the cubes get processed.
Thanks so much,
Silaphet,
Check: http://www.sqlmag.com/Article/ArticleID/8030/sql_server_8030.html
HTH Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
Luis, I used msdb.dbo.backupset and master.dbo.sysdatabases tables to verify last time backup ran. What are metadata or system tables that I can verify the last time the cubes get processed? Thanks,
Silaphet,
Refer to the DSO topic under the books online.
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>