Accessing processing information

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:

Processing start and end date

Error information if any

what are the dimensions/cubes processed

How many records were processed

TIA,

Aiwa

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?|||

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.

Thanks,

Aiwa

|||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.|||

Take a look at the ascmd utility that gives you ability to send processing commands and capture processing events in a log file.

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