Customize BPS to run on Select Days During Certain Hours

Customize BPS to run on Select Days During Certain Hours

Background:

An EXTOL Business Integrator 2.6 customer would like to run their business process script (BPS) on select days, and select hours of the week. Given the limitations of EBI's Scheduler, we upgraded the current Business Process Script to include date and time logic.

EXTOL Business Integrator (EBI) Date and Time Logic applied

Set-up Current Date/Time Tasks

In the steps below, we set-up the EBI tasks to retrieve current date and time.

EXTOL Business Integrator (EBI) Retrieve Date and Time via Tasks
  • Get the current date with Date – Get Current Date.
  • Convert the current date to a string with Date – Convert to String. This convert is for the day of the week.
  • Convert that same current date to a string with Date – Convert to String. This convert is for the time of day.

Once retrieved, we convert the time of day string into a number with Convert to Number

Compare Current Date Tasks

We now compare the day of the week string with two separate values. One is Sat and the other is Sun. If it does not match either of those values it will run all the Business Processes normally.

EXTOL Business Integrator (EBI) Retrieve Date and Time via Tasks

Compare Current Time Tasks

If it matches either of those values. It will then check the time of day to two values. If the value of the day is Sat, a Compare Values task will compare the number 50,000, which stands for 5am. If the time of day value is greater or equal to 5am then all the normal Business processes tasks will run. If not the Business Process will end.

If the value is Sun, a Compare Values task will compare the number 60,000, which stands for 6am. If the time of day value is greater or equal to 6am then all the normal Business Processes will run. If not than the Business Process will end.

EXTOL Business Integrator (EBI) Retrieve Date and Time via Tasks



By: on
A free web counter provided by GoStats.