• Create a job in SQL Agent.

    Job Step Type of SQL Server Analysis Services Command

    Command below

    <Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

    <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>******************BUT YOUR CUBE DATABASE NAME HERE******************</DatabaseID>

    </Object>

    <Type>ProcessFull</Type>

    <WriteBackTableCreation>UseExisting</WriteBackTableCreation>

    </Process>

    </Parallel>

    </Batch>

    Also ensure that you have given the SQL Agent account the access it needs on the right directories etc.