locked
Automated process to clear completed batches RRS feed

  • Question

  • Hi ,

    Can some one please explain how to clear completed batches in MDS automatically, I mean is there a sql code which we can execute using a  sql server agent job to clear the jobs.

    Thanks ,

    Nagesh.


    • Edited by Nag1234 Thursday, January 22, 2015 11:13 PM
    Thursday, January 22, 2015 11:09 PM

Answers

  • In the SQL vnext, we will provide a sql job to clean up the completed batch and transaction logs based on the retention policy.

    In the next SQL11/SQL14 CU, we will provide a set of sproc, so customer can call the sproc manually to clean up. We will post a blog for more details, once the CU is released.

    Tuesday, February 3, 2015 10:17 PM

All replies

  • Any ideas for Nagesh? Any good docs on this topic?

    Thanks!


    Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Monday, January 26, 2015 8:58 PM
  • Seems not many companies not uses MDS and not very familiar with my question ....
    Thursday, January 29, 2015 10:21 PM
  • In the SQL vnext, we will provide a sql job to clean up the completed batch and transaction logs based on the retention policy.

    In the next SQL11/SQL14 CU, we will provide a set of sproc, so customer can call the sproc manually to clean up. We will post a blog for more details, once the CU is released.

    Tuesday, February 3, 2015 10:17 PM