Hi,
We are running Pro*C batch jobs on maestro on a daily basis.We experienced an unusual problem yesterday.Two of the batch job(both accessing different tables and inserting in different tables) just exited out while executing and their status showed that they were successful..However,the unix and oracle proceses were still running..One more interesting point is that this happened approximately at the same time..We verified with the DBA's and they said nothing was wrong with the database at this time.If something was wrong with the processing,the code is written in such a way so as to handle oracle and unix errors..Has anyone encountered such a problem before?..Or else is there any reason why this could happen?
Please respond.
We are running Pro*C batch jobs on maestro on a daily basis.We experienced an unusual problem yesterday.Two of the batch job(both accessing different tables and inserting in different tables) just exited out while executing and their status showed that they were successful..However,the unix and oracle proceses were still running..One more interesting point is that this happened approximately at the same time..We verified with the DBA's and they said nothing was wrong with the database at this time.If something was wrong with the processing,the code is written in such a way so as to handle oracle and unix errors..Has anyone encountered such a problem before?..Or else is there any reason why this could happen?
Please respond.