Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

BizTalk SQL polling -- once per day...

24 views
Skip to first unread message

Adman

unread,
Sep 25, 2009, 2:09:44 PM9/25/09
to
I need to send data somewhere every day at 2:45pm.

I have a stored proc to retrieve the data and mark it as sent.
I have the proper schemas and maps, and everything is great.

The scheduling of SQL polling doesn't really jive with what I want to
do. I could set the thing to run "every 24 hours", but what time will
it actually run?

I'm hoping that I can give it a service window of, say, 2:44pm to
2:45pm, and then set it to poll at any time interval greater than 1
minute (like, every half hour or something).

Do you suppose that will work?

Thanks!
Adman

Dan Rosanova

unread,
Sep 25, 2009, 3:55:44 PM9/25/09
to
I think that will work, but would be worried about polling requests
queuing (just something to check). There is a Scheduled Task adapter
out there as well.

Kind Regards,
-Dan

Adman

unread,
Sep 30, 2009, 4:12:29 PM9/30/09
to
As a followup...

I set the service window on the Receive Location to run from 3pm to
3:01pm.
I configured the SQL polling to poll once an hour (an arbitrary amount
greater than one minute, the size of the service window).

It apparently works the way you might expect... Everyday at 3pm the
poll happens, just the way I wanted.

Adman

Dan Rosanova

unread,
Sep 30, 2009, 4:59:55 PM9/30/09
to
Wow, cool, thanks for posting that solution. That is pretty cool!

Sincerely,
-Dan

mee

unread,
Dec 19, 2009, 1:41:27 PM12/19/09
to

"Adman" <asp...@yahoo.com> wrote in message
news:69e9dbfd-856f-4f44...@d15g2000prc.googlegroups.com...

It all depends on what and how much you are sending at once.

Kaylee.

0 new messages