Answered by:
Biztalk 2009 schedule task adapter

Question
-
Hi,
I l am ooking for a schedule task adapter that works with biztalk. Any recommendation?
Thanks,
JennyMonday, November 16, 2009 3:47 AM
Answers
-
- Proposed as answer by Sandro PereiraMVP, Moderator Monday, November 16, 2009 2:28 PM
- Marked as answer by Andrew_ZhuModerator Monday, November 23, 2009 1:19 AM
Monday, November 16, 2009 4:51 AMAnswerer -
Hi,
You should use Greg suggestion.
Related thread http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/3734729d-9361-44e0-80f9-785828c24f77
Sandro Pereira - http://sandroasp.spaces.live.com/blog/ http://www.devscope.net/WhatWeDo/Integration/tabid/107/Default.aspx- Marked as answer by Andrew_ZhuModerator Monday, November 23, 2009 1:19 AM
Monday, November 16, 2009 2:30 PMModerator -
Personally, I like to use other functionality rather than the scheduled task adapter because of better support and configuration options. What I do is create a SQL Agent job to modify a value in a custom database table in SQL. Then I use the new notification capabilities of the WCF-SQL adapter to use a polling statement on the custom database table, basically watching for changes. It was also possible to develop similar functionality using the older SQL adapter.
The SQL agent job has a lot more scheduling options and comes out-of-the-box with SQL.
Thanks,
If this answers your question, please use the "Answer" button to say so | Ben Cline- Proposed as answer by Abdul Rafay Monday, November 16, 2009 4:09 PM
- Marked as answer by Andrew_ZhuModerator Monday, November 23, 2009 1:19 AM
Monday, November 16, 2009 3:29 PMModerator
All replies
-
- Proposed as answer by Sandro PereiraMVP, Moderator Monday, November 16, 2009 2:28 PM
- Marked as answer by Andrew_ZhuModerator Monday, November 23, 2009 1:19 AM
Monday, November 16, 2009 4:51 AMAnswerer -
Hi,
You should use Greg suggestion.
Related thread http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/3734729d-9361-44e0-80f9-785828c24f77
Sandro Pereira - http://sandroasp.spaces.live.com/blog/ http://www.devscope.net/WhatWeDo/Integration/tabid/107/Default.aspx- Marked as answer by Andrew_ZhuModerator Monday, November 23, 2009 1:19 AM
Monday, November 16, 2009 2:30 PMModerator -
Personally, I like to use other functionality rather than the scheduled task adapter because of better support and configuration options. What I do is create a SQL Agent job to modify a value in a custom database table in SQL. Then I use the new notification capabilities of the WCF-SQL adapter to use a polling statement on the custom database table, basically watching for changes. It was also possible to develop similar functionality using the older SQL adapter.
The SQL agent job has a lot more scheduling options and comes out-of-the-box with SQL.
Thanks,
If this answers your question, please use the "Answer" button to say so | Ben Cline- Proposed as answer by Abdul Rafay Monday, November 16, 2009 4:09 PM
- Marked as answer by Andrew_ZhuModerator Monday, November 23, 2009 1:19 AM
Monday, November 16, 2009 3:29 PMModerator -
You can follow this thread:
http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/3734729d-9361-44e0-80f9-785828c24f77
Sandro Pereira - http://sandroasp.spaces.live.com/blog/ http://www.devscope.net/WhatWeDo/Integration/tabid/107/Default.aspxFriday, November 20, 2009 10:14 AMModerator