@ Pradeep: I am not aware of SP_PURGE_JOBHISTORY.

what it will do. Is there any alternate solution of fixing the bug.