Process OLAP Database with SQL Agent Job

Was this article helpful?
3 out of 4 found this helpful
Return to top

Comments

3 comments

  • jasmina markovic

    Thanks for the article. I have a doubt about could I use SQL job to process several partitions with process add... Namely, I want to make two jobs one with full processing in weekend time and all partitions to process with process Add during a working week. I found that cube must be processed with the process full option when called from SQL agent, but can't find what's about partitions. Greetings

    0
    Comment actions Permalink
  • Kepion Support

    Hi Jasmina,

     

    Similarly to what is explained above, you will want to right-click the Partition of choice and select the Process option. In the pop-up window, select Process Add using the Process Options drop-down.

     

    Select the Configure option and configure the Data source and the table name. Press OK. Once you have done that, follow the same steps as the Process Full scripting.

    1
    Comment actions Permalink
  • jasmina markovic

    Hi Joyce, thanks a lot for the fast reply and detailed explanation. Jasmina

    0
    Comment actions Permalink

Please sign in to leave a comment.