Auto Action Trigger after DB updating a field in comprofiler table

Looking for an Auto Action triggered after executing a DB statement updating a field in user profile.

Trigger onAfterUpdateUser seems not to be suitable here as it does not fire.
Is a trigger specific to Joomla required?

Thank you.

onAfterUserUpdate is fired when a user is updated from frontend and onAfterUpdateUser is fired when a user is updated from backend. Use either of those or both depending on your needs. Their variables are all the same with var1 and var2 being the up to date user object and var3 being the object before changes were applied. So you can check if a field changed its value with the following condition

[var1_field_name] Not Equal To [var3_field_name]

This is exactly how we do it with most of our Auto Actions.

However, in this case, neither the frontend user nor backend admin initiates the update but an application.
The app simply switches a flag in comprofiler from 1 to 0 because a subscription has expired.
This hides a CB Tab from being display and it executes properly.

But consequently an Auto Action is required to do some housekeeping:
1) unpublish a CB Content Module
2) delete some content from user's profile

For this transaction we're looking for correct type of trigger listening to DB updates.
onAfterUpdateUser seems not to work here.

Thank you.

I can't help you in regards to your application updating users. Your application isn't firing CB triggers when making the changes, which it's probably just doing directly on the database. This means CB Auto Actions can't do anything for you.