How to purge a service ? | Community
Skip to main content
A
antoineb5376317
July 23, 2019
Solved

How to purge a service ?

  • July 23, 2019
  • 2 replies
  • 1209 views

Hello,

I want to create a technical workflow to purge a service (subscription) every day. I tried some activity but it's look impossible. Maybe with a SQL activity and use truncate ?

Do you have any solution or the good SQL to purge a specific service ?

Thank you

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jonathon_wodnicki

    Hi,

    Use the Subscription Services activity in your workflow. The Update data activity will also work.

    Truncate is the most performant if you only want to wipe the NmsSubscription table and do nothing else- be sure to insert Campaign's zero record afterward.

    Thanks,

    -Jon

    2 replies

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    July 23, 2019

    Hi,

    Use the Subscription Services activity in your workflow. The Update data activity will also work.

    Truncate is the most performant if you only want to wipe the NmsSubscription table and do nothing else- be sure to insert Campaign's zero record afterward.

    Thanks,

    -Jon

      A
      antoineb5376317Author
      July 24, 2019

      Thank you

      Terms & ConditionsAccessibility statement

      Loading footer...