Accessing processing information RRS feed

  • Question

  • Hi,

    We need to access some of the processing information that are displayed when processing from BIDS. Is there any way to access this info send it to the event viewer (or anywhere) when processing a cube from the command-line?

    I would like to see:

    1. Processing start and end date
    2. Error information if any
    3. what are the dimensions/cubes processed
    4. How many records were processed



    Friday, July 28, 2006 3:15 PM


All replies

  • BIDS, SSMS and SQL Profiler establish a trace connection to the server and the server sends notifications.

    Is your goal to write a program, which sends processing request and needs to capture the processing events or you already have some program and it needs to listen what the server does in response to that program's request?
    Friday, July 28, 2006 3:22 PM
  • I am hoping that there is an out of the box solution for this. We follow closely our DW processing and we would like to apply the same follo-up on our cube generation process.

    We have developed some tools to do the DW generation follow-up but if an out of the box features exist to do that with AS2005 we would be more than willing to use it. Best case scenario would be to be able to capture processing events in the event viewer.




    Friday, July 28, 2006 4:48 PM
  • By "event viewer" do you mean SQL Profiler? When it is running it captures the trace events from all the clients you have. You can specify filters on the events.
    Friday, July 28, 2006 6:17 PM
  • Take a look at the ascmd utility that gives you ability to send processing commands and capture processing events in a log file.

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Friday, July 28, 2006 7:16 PM