mail trigger-previous month

[priya@90]

Hello Everyone,

I have zero knowledge in Event studio. Can anyone has done before?

The Event condition is when count of record in the FACT table is zero for previous month, then email has to be triggered to clients.

Thanks,

[dougp]

Event Studio runs the event on a schedule and will trigger an action based on comparison of the last two runs of the query.  If the results change, the action is fired.  (OK, you can set it to run every time, too...)

Craft your query such that the logic causes a new row to appear at the appropriate time.