The program finally completed. We defined memory limits of the ForeGround and BackGround Memory for App A and a Foreground memory limit on App B.

But the program took 7 hours to complete. But we have noticed that when the tables are empty it takes longer to run. We are hoping that from the next run of this job, it will not take as longer.

Thanks.

Ria