Re: Processing Cubes

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,

I am using the regular SQL Job and in the job step I choose the type
"SQL Server Analysis Services Command" and in the command window I put the
below XMLA commands.

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine";>
<ErrorConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<KeyNotFound>ReportAndStop</KeyNotFound>
<NullKeyConvertedToUnknown>IgnoreError</NullKeyConvertedToUnknown>
<NullKeyNotAllowed>IgnoreError</NullKeyNotAllowed>
</ErrorConfiguration>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<Object>
<DatabaseID>Homeroom Analytics1</DatabaseID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Batch>



/
ERS

"Jéjé" wrote:

do you use the integrated SQL Agent / job / task which execute XMLA
commands?
or do you use the ASCMD utility ?

"ERS Developer" <ERSDeveloper@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BAB99B95-8EAD-47D5-95E5-CE35232C1F84@xxxxxxxxxxxxxxxx
Hi,
What I have got so far is. if we use the error configuration in the xmla
commands it logs to the job history.

But it doesn't fail the SQL job. It always says step succeded and no
alerts
goes out.

/
ERS

"susansandster@xxxxxxxxx" wrote:

Ooh, I would really like to know the answer to this question as well.
We were just discussing the frustration of not getting errors even when
the job failed miserably lastnight. We did figure out why it was
failing (our bad), but had to go into the history logs to research.
Hopefully there is a way to add this functionality to the XMLA?

ERS Developer wrote:
Hi,

Currently I am using XMLA commands in a SQL Job to process the cubes.
If
some error occurs during the process the cube rolls back to its intial
state
and
the sql job returns no error.

How can we send alerts to DBA when the cube process fails.

Thanks
S



.

Relevant Pages

  • Re: Processing Cubes
    ... the ascmd utility return 1 if there is a failure and 0 if not. ... I am using the regular SQL Job and in the job step I choose the type ... below XMLA commands. ... >>> Currently I am using XMLA commands in a SQL Job to process the ...
    (microsoft.public.sqlserver.olap)
  • Re: Processing Cubes
    ... We were just discussing the frustration of not getting errors even when ... Currently I am using XMLA commands in a SQL Job to process the cubes. ... How can we send alerts to DBA when the cube process fails. ...
    (microsoft.public.sqlserver.olap)