Hi

I'm working in a system where there is an intermittent problem with locked records stopping jobs from running. As the users only sees a message stating Trying to lock record etc.....

I want to pass this error to my own error handler to display the record that cannot be locked.

I set reprocess to 1 and in the error handler display the key of the current(locked record) and then retry.

My question is. Is this bad from a performance view or are there any other ways to handle this. I should add I have little control over the data environment due to the nature of the overall system.

Thanks

Nick Mason