SQL Server Performance Forum – Threads Archive
Script to find last time Cubes get processedHi 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,
HTH Luis Martin
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,
Refer to the DSO topic under the books online.
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.