Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Adapter Receive Location DB Polling
- This topic has 4 replies, 1 voice, and was last updated 9 years, 2 months ago by
community-content.
-
AuthorPosts
-
-
June 30, 2010 at 11:38 AM #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?
-
June 30, 2010 at 3:31 PM #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/
-
July 1, 2010 at 8:32 AM #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?
-
July 1, 2010 at 8:54 AM #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.
-
-
-
July 1, 2010 at 9:35 AM #25114
I forgot to go thru the process of adding the New adapter. I now see the light. Thanks!
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.