Job Scheduling for Expected Event Monitoring

[former_member655821]

Hi,

I am trying to schedule a job for expected event monitoring "/SAPTRX/EE_MONITOR", but when i schedule the job hourly then the job is getting overlapped with the privious one which is producing dump - DBSQL_DUPLICATE_KEY_ERROR.If we have to run this job hourly only then how can we schedule the job is such a way that each time when job runs it will check  for the completion of privious job.please suggest.

Thanks

Vaibhav

[Former Member · Accepted solution]

Hi Vaibhav,

We had a similar requirement in the previous project but we have done below option as we can't predict how long the job runs.

In my opinion, you can achieve like below.

Step -1:

1. Go to SE38 and create a variant for program RSBTONEJOB2.

2. Add Step 2 Job name, Report /SAPTRX/EE_MONITOR and Variant.

Step - 2.

1.Add Step 1 of program, Report RSBSTONEJOB2 and new Variant.

2. Add program RSBTONEJOB2 and newly added variant

3. Add step 2 and include program /SAPTRX/EE_MONITOR.

Outcome:

Step 1 RSBSTONEJOB2 checks the previous job program /SAPTRX/EE_MONITOR runs and it would cancel the current one without making any dump.

If you have CPS scheduling tool, you can achieve this function, i believe.

Or else, just simply calculate the maximum amount of time it runs in a day.

For example -

9 AM to 12 PM - it runs close 2 hours but runs after 2 PM only one hour.

In that case, you can schedule multiple job name or same name with same program to schedule in different custom time daily.

Regards

GGOPII