Scheduling jobs with table update triggers

Garybary
New Contributor III

Hi all,

Lately I've been experimenting with the newish feature of scheduling jobs on a table update trigger. There's one thing thats blokcing me from implementing it however and I was hoping someone found a solution to it.

We occasionally perform a vacuum operation in our PRD environment. This is not synchronized across the platform and as such some of my DP's in the platform receive an update but others dont. When these then get updated on a daily load the day after, it oftentimes begins to run with only half of its tables actually updated.

Do you know of ways to filter on specific table update trigger types (e.g. we can filter on specific operations) or ways to make this more stable?

Thanks for reading!