Batch Job Rescheduling

[Former Member]

I am looking for some suggestions on how to overcome the following problem with minimal effort.

I have a report that is scheduled to run 4 times a day - 8 AM, 10 AM, 2 PM and 4 PM.

Each job only captures sales orders that have been created/changed since the previous run - with the 8 AM capturing orders from 4 PM on the previous day.

This works great - except when production has to shut down for whatever reason - then we have to find out what jobs were not run and manually input the variants to cover the time frames needed. This takes time as we have 9 versions of the jobs - and will have a possible 20 or more in the near future.

One way is to just run one job to cover all variants and email recipients for the last 24 hours and have the users sort out the sales orders that may have been repeated and to get the ones that are specific to their divisions.

I am looking for a way to automate this recovery in an easier fashion.

This involves our business, development and basis teams.

Any suggestions would be most appreciated.

Scott

[Former Member]

Hi Scott,

You could create a specific entry in table TVARV (or in a custom table whatever you prefer) containing date and time of the last run of your job. At the begining of your program, retrieve this value and extract all sales order created/modified since this date and time and then update the value in TVARV with current date and time.

This way, TVARV will always contain the date and time of the last extraction and you don't have to worry about production shut down.

If you have different jobs, you can always create different entries in TVARV.

Regards.

Nicolas