locked
Biztalk 2009 schedule task adapter RRS feed

  • Question

  • Hi,

    I l am ooking for a schedule task adapter that works with biztalk. Any recommendation?

    Thanks,

    Jenny
    Monday, November 16, 2009 3:47 AM

Answers

  • Monday, November 16, 2009 4:51 AM
    Answerer
  • 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
    Monday, November 16, 2009 2:30 PM
    Moderator
  • 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
    Monday, November 16, 2009 3:29 PM
    Moderator

All replies

  • Monday, November 16, 2009 4:51 AM
    Answerer
  • 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
    Monday, November 16, 2009 2:30 PM
    Moderator
  • 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
    Monday, November 16, 2009 3:29 PM
    Moderator
  • 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.aspx
    Friday, November 20, 2009 10:14 AM
    Moderator