none
scheduling a SQL adapter once a week to execute a stored proc ? RRS feed

Answers

All replies

  • Hi,

    The new SQL adapter  has the property "pollingIntervalInSeconds" which is of type Int32 (Max Value = 2147483647).

    So, you can specify upto 596523 ( i.e 2147483647/3600) hours.  

    or 34855 days.

    Though , we have some timeout values  like (receive timeout etc. ) which take timespan as input (Max value ~ 24 days).

    This is still much higher than a week.


    Hope this helps !
     
    Thursday, February 11, 2010 8:17 AM
  • HI
    I have looked into the "Microsoft.BizTalk.Adapter.Sql.dll" by diassembling using .net reflector and found out that the function calculating the next activation time is converting into milli seconds, i pasted the code below
    public DateTime GetNextActivationTime()
    {
        return (DateTime.Now + TimeSpan.FromMilliseconds((double) (0x3e8 * this.seconds)));
    }
    So that means we have only 596 hours like the old sql adapter;
    596 * 60 * 60 * 1000 = 2145600000. Though 596 hours is enough in our case, just wondering if there is any work around from microsoft, coz this has been reported when the old adapter came out as well.
    Thursday, February 11, 2010 2:30 PM
  • Hi,

    Why don't you use the SQL Server Agent to do the scheduling?
    With the new WCF-SQL adapter you can use query notification.

    http://seroter.wordpress.com/2009/01/12/query-notification-capability-in-wcf-sql-adapter/

    Kind regards
    Tim D'haeyer
    Tuesday, February 16, 2010 11:58 AM