SQL Adapter Receive Location DB Polling

Home Page Forums BizTalk 2004 – BizTalk 2010 SQL Adapter Receive Location DB Polling

Viewing 2 reply threads
  • Author
    Posts
    • #25095

      I have a Receive Location that uses the SQL Adapter in order to schedule the initiation of an Orchestration by retrieving a specific message that the orchestration subscibes to. I want to scheduled it to poll weekly at 7:00 AM on Monday mornings. I set my polling interval for every at 168 hours and I enable the Receive Location.

      Will settng the Start Date to the first Monday I want this thing to run and time window to 7:00 AM establish the actual polling start date and time.

      And lets say for some reason I need to disable the Receive Location. When I restart it, can I again use the Start Date (i.e. set it for the very next Monday) and time window to establish the polling start date and time again?

    • #25104

      Yes, changing the start time before you enable the receive location will schedule the first poll.

      However, you will also need to do this everytime you restart the host instance or restart the server. And if the host instance or server restart automatically at 2:00 am on a Wednesday morning, your schedule will be shifted to this new time.

      Could I suggest this adapter: http://biztalkscheduledtask.codeplex.com/

       

      • #25111

        Yes – I would certainly consider it. I downloaded and installed. The install appeared to go fine but I don;t see the adapter anywhere in BizTalk. ARe there any instructions on how to use this?

        • #25112

          I recently downloaded and installed the BizTalk Scheduled Task Adapter on my BizTalk 2009 development environment and have been using it successfully to develop a solution that requires a scheduled event to take place.

          It has quite a lot of scheduling options so may be perfect for your needs.

          My notes from installing and configuring a receive location using the Scheduled Task Adapter can be found here:

          Installing the Scheduled Task Adapter

          Scheduled Task Adapter Receive Location

          Hopefully these will be of use to you.

          Cheers

          Stu.

           

    • #25114

      I forgot to go thru the process of adding the New adapter. I now see the light. Thanks!    

Viewing 2 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.