Data Driven Trigger when *all* conditions are met

Follow

Simon Gao

• March 30, 2016 05:33

In Data Driven trigger, I can select from:

 

Run when any of the following are updated:

a

b

c

 

Is there a way to configure it such that the job is only run when all of the conditions are met?

0

• 

  Jason Arrigo

  • March 30, 2016 14:23

  Hello Simon,

  This is where you should employ the settings for Data Driven timing. When you select parameters around "If all of the following conditions are met" you can set it so that the workbook will:

  ONLY run when
  [SourceA] is not older than [NOW()-5m]
  [SourceB] is not older than [NOW()-1d]
  [SourceC] is not older than [NOW()-1d]

  What this will ensure is that your workbook will run if and only if all 3 source artifacts have been run within a certain amount of time. In the case of the above example, I know that Sources B and C run daily and Source A is run Manually. I only want my workbook to run in a Data Driven fashion when when someone triggers Source A AND Sources B&C have run in the last day.

  This will control for and make sure that all of your sources need to have run to completion before the Workbook is run.

  I hope this clears up your question.

  Thanks,
  Jason

   

  0

  Comment actions Permalink
• 

  Permanently deleted user

  • August 21, 2018 19:18

  How does datameer interpret OR logic in selecting multiple triggers? Will the workbook run only once. i.e. when the first change to the data indicated by the trigger changes? Or will it run multiple times, i.e. when each dataset checked changes? 

  0

  Comment actions Permalink
• 

  Alan Mark

  • August 21, 2018 19:29

  Hi Phillip,

  Trigger conditions are not OR logic, they are AND logic.  All conditions must be met for the trigger to kick off.

  0

  Comment actions Permalink

Please sign in to leave a comment.