WCF-SQL adapter scheduler RRS feed

  • Question

  • Dear Friends,

    we have created the WCF-SQL adapter to fetch data from database.

    Business Requirement: Fetch the data from SQL and send to customer every 2hrs from 9am to 5pm

    Our Solution: We have created receive location scheduler service window from 9am to 5pm and set WCF-SQL binding  PollingIntervalInSeconds=7200.

    Issue: when ever we restart the host instance or application, WCF-SQL binding PollingIntervalInSeconds starting from zero seconds

    please advice how to resolve this issue. thanks

    Friday, March 13, 2020 7:22 AM

All replies

  • If you restart the host instance, and it is in the service window, then it will trigger.

    I would implement the logic in the database instead with a stored procedure, and have a table that contains the record of when it was last executed.  If it isn't time, don't return any rows.   Then have you adapter poll at a regular interval that is less that the variance that is acceptable to the business.

    Sunday, March 15, 2020 7:02 AM
  • Dear Colin,

    Thanks for you advice, we have implemented in store proc and its working fine

    Wednesday, July 29, 2020 3:57 AM