I’ve noticed that when I have a transformation type of DB read that includes multiple DB statements (which is probably a bad IMAN hack anyway) I get the attached results in the audit.

What’s a better way to do what I want to do? I guess I am looking for some design advice. Details below.

Audit email:

What I’m trying to do (which works but gives me the audit notice of failure):

--- this job finds the current records where a price list exists that starts today, inserts them to a staging table, and then directly deletes from Sage.