Skip to main content
Level 2
Apr 29, 2022 10:15 AM UTC
Solved

How to check if the target table got refreshed before triggering any workflow?

I need to set a dependency on the automated workflows. I want my workflow to go to backend table and see if the table got refreshed with today's date before triggering the workflow. If table didn't get refreshed, then it should send out an alert and re-trigger  after some time may be 1 hour for an example. Can we achieve this? if yes how?

 

Thanks in advance!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Marcel_Szimonisz
Marcel_SzimoniszAccepted solution
Community Advisor
May 1, 2022 2:59 AM UTC

Hello @data_guy ,

if you use audit trail attribute you can check last modified date and then on workflow divert to loop retry with alert and wait activity. 

 

Marcel

4 replies

Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity AdvisorAccepted solution
Community Advisor
May 1, 2022 2:59 AM UTC

Hello @data_guy ,

if you use audit trail attribute you can check last modified date and then on workflow divert to loop retry with alert and wait activity. 

 

Marcel

Translate
Data_guyAuthor
Level 2
May 2, 2022 6:58 AM UTC

Thanks Marcel! Somehow I am not able to see Audit under Administration. Using 19.1 build

Translate
DavidKangni
Adobe Champion and Community Advisor
Adobe Champion and Community Advisor
May 3, 2022 3:48 PM UTC

Audit trail started from Release 19.1 - Build 9026. You need to update your app server.

Thanks,

David

Translate
David Kangni