DSXchange

Good Morning,
I am just getting started on a project with a requirement to fail any job that doesn't get a match on a reference table. I currently have SQL using a UDB left outer join that would return nulls for any fields not found on the reference table(set this up before teh new requirement). I am playing around with multiple ideas with one more complex than the other. Is there a simple way to have this job fail?
Thanks - - John

We created a routine that is called in a stage variable derivation when something fails that should never fail, typically a reference lookup. It calls 'UtilityAbortToLog' from what I recall, which allows us to not only abort the job but also record in the log why we are aborting it.