Post reply

Analysis services Database Processing

  • September 13, 2010 at 10:24 am

    #240270

    Hello Everyone.

    I have a analysis services database and I want to schedule the automation of the database process. I copied the script generated by right clicking the analysis services database and again clicking on process. I have the following script now can I schedule this script to run everyday if so can you please provide me the steps to do that.

    Script:

    <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" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">

    <KeyErrorLimit>-1</KeyErrorLimit>

    </ErrorConfiguration>

    <Parallel>

    <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">

    <Object>

    <DatabaseID>Lab</DatabaseID>

    </Object>

    <Type>ProcessFull</Type>

    <WriteBackTableCreation>UseExisting</WriteBackTableCreation>

    </Process>

    </Parallel>

    </Batch>

    Thanks.

  • September 13, 2010 at 10:35 am

    #1220182

    If you're running SQL Agent, you could go there, add a new job. In the job, add a new Step, set the type to be SQL Server Analysis Services Command and paste your XMLA to the command window.

    HTH,

    Steve.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply