Skip to main content
antoineb5376317
Jul 23, 2019 12:55 PM UTC
Solved

How to purge a service ?

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.
    Jonathon_wodnicki
    Jonathon_wodnickiAccepted solution
    Community Advisor
    Jul 23, 2019 6:09 PM UTC

    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

    View in thread

    2 replies

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    Jul 23, 2019 6:09 PM UTC

    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

    Translate
      antoineb5376317Author
      Jul 24, 2019 7:46 AM UTC

      Thank you

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...