Mar 282017
 

We have built a process to synchronize contacts between our Informix back-end ERP and Constant Contact.

Now that we have pagination working, we wanted to run the process every Friday.

 

Within BizTalk’s receive location only allows us to specify what time of the day to run it, it does not get any broader than the scope of a day.

In a conference call today, I talked myself into a solution. Using the Data Available statement in the receive location, I simply wanted a number zero on every day except Friday.

 

Here is the Data Available Command:

SELECT COUNT(*)

FROM SYSTABLES

WHERE TABID = 1

AND WEEKDAY(TODAY) = 5

Sorry, the comment form is closed at this time.