Job is failing and time out for sql fetch operation

Some examples running with Control-M and Control-EM database.
Post Reply
User avatar
deeshw
Nouveau
Nouveau
Posts: 2
Joined: 22 Nov 2008 12:00

Job is failing and time out for sql fetch operation

Post by deeshw » 22 Nov 2008 3:20

Hi,

We have a job scheduled to do Cleanup of the oracle Database data(we have a SQL query to do so). Its running on BEA Tuxedo. Generally the Job was taking 30 mins but now its job is failing after processing for more then 1 hour and getting timeout. Please suggest how to resolve and increase the performance( any parallel processing of sql..??) pls help

Regards,
Deesh

Post Reply