| Author |
Orchestration call sproc on user defined schedule?
|
|
| Code Boy 2006-04-01, 2:38 pm |
| I have a BizTalk 2004 orchestration that I want to run a SQL stored
procedure at pre determined time intervals that are user configurable. I
know how to have the orchestration call a stored procedure using a polling
frequency but am not sure how to do so based on some user defined schedule.
Any advice, articles, code samples etc. that could assist me would be
greatly appreciated. Thank you.
| |
| Greg Forsythe 2006-04-01, 2:38 pm |
| You can put the scheduling code in the stored proc.
The stored proc is called every 5 or 10 minutes but it checks it schedule
and only returns data if the current time matches the schedule time.
Greg
"Code Boy" <CodeBoy@microsoft.com> wrote in message
news:e3Kbw5CVGHA.224@TK2MSFTNGP10.phx.gbl...
>I have a BizTalk 2004 orchestration that I want to run a SQL stored
>procedure at pre determined time intervals that are user configurable. I
>know how to have the orchestration call a stored procedure using a polling
>frequency but am not sure how to do so based on some user defined schedule.
>Any advice, articles, code samples etc. that could assist me would be
>greatly appreciated. Thank you.
>
>
| |
| Code Boy 2006-04-01, 2:38 pm |
| Under this scenario the schedule data would be stored in the database as
well as opposed to a config file? Thanks.
"Greg Forsythe" <greg.forsythe@gmail.com> wrote in message
news:O73KDjDVGHA.5996@TK2MSFTNGP10.phx.gbl...
> You can put the scheduling code in the stored proc.
> The stored proc is called every 5 or 10 minutes but it checks it schedule
> and only returns data if the current time matches the schedule time.
>
> Greg
>
> "Code Boy" <CodeBoy@microsoft.com> wrote in message
> news:e3Kbw5CVGHA.224@TK2MSFTNGP10.phx.gbl...
>
>
|
|
|
|