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
Design question to fail jobs
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers