Hello,
I have a workflow that relies on a temp table (Drop / create daily).
I would like to receive an email on when this table is not created / not exist (scheduled task).
How could I achieve it ?
Thanks
Hi @Borisham ,
One way would be to use a "Count Records" tool after your table tool. If the table is not there, that tool will return the value of zero, else if it is there it will return the value of one.
So then you can use a filter tool, checking if the count is 0 and out of the True output anchor you can stick an e-mail tool to send an email.
Hopefully that makes sense. Let me know if you any questions.
Cheers,
Angelos