Design question to fail jobs

JPalatianos · Post by **JPalatianos** » Wed Mar 26, 2008 8:13 am

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

chulett · Post by **chulett** » Wed Mar 26, 2008 8:22 am

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.