scheduled jobs stuck after a certain time

[Former Member]

We are using SAP MII 12.2 SP6 Patch 5 (20.12.2013).

We have many scheduled jobs with different time periods.

Most jobs are scheduled with a period of 10 or 20 seconds.

Our problem is that the jobs will run for a certain time (can be 2 hours, but as well 2 days) properly, but suddenly single jobs stuck and  we have to disable/enable the job to resume in running status.

SAP proposed to use latest MII release. First we used SAP MII 12.1 SP5 Patch 3. But the release upgrade to SAP MII 12.2 SP6 Patch 5 did not improve the situation!

Do you have any idea how to get rid of this problem?

Please provide your suggestions.

Thanks & Regards,

Michael

[raj44]

Hi Michael,

We have faced this issue, the solution can be to reset the indexes at your DB; as your scheduled jobs are running is small intervals. This makes the performance of DB slow which in turn results scheduled jobs to get stuck.

Resetting your indexes at the DB level will improve your application's performance considerably. Preferably, indexes should be reset quite often in your case to ensure your jobs are not stuck.

Regards

R