SQL Server Performance

Script to find last time Cubes get processed

Discussion in 'Analysis Services/Data Warehousing' started by kmounkhaty, May 2, 2006.

  1. kmounkhaty New Member

    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,
    kmounkhaty, May 2, 2006
    #2

  2. Luis Martin Moderator

    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 Martin, May 2, 2006
    #2

  3. kmounkhaty New Member

    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,

    kmounkhaty, May 3, 2006
    #2

  4. satya Moderator

    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.
    satya, May 3, 2006
    #2

Share This Page