How to purge a service ?

Avatar

Avatar
Validate 1
Level 1
antoineb5376317
Level 1

Likes

2 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
antoineb5376317
Level 1

Likes

2 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
antoineb5376317
Level 1

23-07-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

23-07-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

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
antoineb5376317
Level 1

Likes

2 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
antoineb5376317
Level 1

Likes

2 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
antoineb5376317
Level 1

24-07-2019

Thank you