in SQL I can force an exception (ie SQL state), but the net result is that the Job Step gets an RC 8.
Is there any way I can elevate the RC to a higher value ? Note that the step could fail for another condition - eg, insufficient user privileges - and for these I would always want to see RC 8. But I need to be able to identify a special condition based on RC.
I'll provide more details tomorrow as I'm writing this away from work.