synchronize cube using sql agent

  • I have created an XML script using synchronization wizard. It has the source connection, but no target connection. I ran it from ssms with my query window connected to target ssas db. I want to automate this as a job on sql agent. How can I modify this script to run it from sql agent so that it syncs correct rtarget ssas db.

    XML Script copied below.

    {

    <Synchronize xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

    <Source>

    <ConnectionString>Provider=MSOLAP.4;Data Source=myserver;ConnectTo=10.0;Integrated Security=SSPI;Initial Catalog=mycube</ConnectionString>

    <Object>

    <DatabaseID>mycube</DatabaseID>

    </Object>

    </Source>

    <SynchronizeSecurity>CopyAll</SynchronizeSecurity>

    <ApplyCompression>true</ApplyCompression>

    </Synchronize>

    }

    Thank you for your help.

  • In your SQL Agent job step where it asks for server, use the target server (this is where the script will be executed and what you will synchronize to).


    I'm on LinkedIn

  • Thank you. That makes sense.

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

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