GilaMonster (9/25/2013)
stevewes (9/23/2013)
our Help desk ticketing application gets lots of email request into a particular table and seem to break when it gets to 100 !! so it's so we can notify the Help desk Admin guy before it does break.I know I'm a little weird, but personally I'd be trying to figure out why it breaks and fix that...
I have to agree with Gail here - fix the problem instead of creating a band-aid to deal with it.
A short story to illustrate a point...
Some years ago, we had an email process to send email generated from an Oracle database. Since the database itself couldn't do email, it was handled by using a Unix ksh script. It also broke when it hit 100. It turned out that the Unix csplit allocated only 2 positions (not 2 bytes, but 2 positions) for an number internally, so we had to limit it to processing 99 at a time. It was re-done later so it didn't suffer from this limitation.
The moral of the story is to look everywhere for your limiting factor and fix the actual problem.