Yesterday we had our cube server go down and reboot. Every hour there's a
processing job which runs.

After the server was rebooted, the job which was running before the reboot
hung (the jobs are executed from a different server than the cube server)
and I had to manually restart it this morning.

Basically what we need to know is the last time the cube was processed (not
the job which does the processing).

Is there any way to query this besides going straight to the cube for a max
date/time? We want to sent up an alert every hour which checks to see if the
cube has been updated within last X hours.

Thanks!

Yes, there is a DSO property which will return date/time last processed.
However, it has been my experience that look at the date/time stamps on the
MOLAP files is just as useful.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote

Yes DSO or ADOMD can be used to find out the last process date and time
please check the code which is using ADOMD

Dim adomdcat As ADOMD.Catalog
Dim adomdcd As ADOMD.CubeDef
Dim strcn As String

Private Sub cmdProcess_Click()
Set adomdcat = New ADOMD.Catalog
strcn = "Data Source=" & txtServer & ";initial catalog=" & txtDatabase &
";provider=MSOLAP"
adomdcat.ActiveConnection = strcn
Set adomdcd = adomdcat.CubeDefs(txtCube.Text)

MsgBox adomdcd.Properties(6).Value
end sub


"Dave Wickert [MSFT]" wrote: