Schedule Biztalk Orchestration

This topic has 2 replies, 1 voice, and was last updated 8 years, 10 months ago by community-content.

Viewing 1 reply thread

Author

Posts
- November 10, 2006 at 12:51 AM #16384
  community-content
  Hi,
  
  Is it possible to schedule a BTS Orchestration based on certain conditions? For example, If a column of a database table says "Y" the orchestration should stop. (probably by a Win Service???) and when the column is "N" it should start functioning…any ideas?
  
  Prasanth
- November 10, 2006 at 3:06 AM #16385
  community-content
  One solution I see is to have a singleton orchestration that check your table column at desired intervals and then perform action according to Y or N flag…
  
  Or maybe you could have an SQL jobb that sends a XML message to a folder if the flag is N, this will trigger the orch. and you could monitor the table column flag and terminate the orch if it's Y…
  
  just some rapid ideas…
  - November 12, 2006 at 3:25 PM #16396
    community-content
    You should also check out service windows on send and receive ports. You can enable and disable ports using a schedule configured on the port.
    
    If you need more control than a start and stop time then check out this utility from Brian Loesgen
    
    http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=CF64CCCF-00DE-4608-9A6F-AC4D25A6AFBB
Author

Posts

Viewing 1 reply thread

The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.