Workbench job that I created on 2/25 & set to append one day back, scheduled job ran multiple times

Roman_K
Roman_K Member
in SQL DataFlows

I built a workbench job on 2/25 & set it on a schedule to append with the logic at the bottom (appending one day in the past at a time). Even though I had it scheduled for once daily, for some reason the job the job ran twice as a "scheduled update". Any idea why this might happen, and is there any documentation of idiosyncratic behaviors that the most recent versions of the Domo workbench or ETL tool might exhibit?

and a4aodt =DEC(VARCHAR_FORMAT(current date -1 day,'YYYYMMDD'))-19000000

image.png
image.png

Answers

  • Roman_K
    Roman_K Member

    Also, what would be the safest way for me to remove the duplicate data for the date 2/25? Would the following process I found on ChatGPT work?

    image.png

Categories