Hi to all,

I want to develop a scheduler using Biztalk Server.  In Orchestration I want
to call a .NET assembly (every day at mid night 12.00), which will connect t
o
DB2 database and takes some data and insert into sql server database.  How
can I do this.

I saw the properties of receive location, where we can use them to schedule
the receive port.  But here, Biztalk has to start automatically without any
receive message (in this orchestration there won't be any input message to
the .NET assembly).  How can I implement this.

Please help.

[ Post a follow-up to this message ]

Help Needed wrote:
> Hi to all,
>
> I want to develop a scheduler using Biztalk Server.  In Orchestration I wa
nt
> to call a .NET assembly (every day at mid night 12.00), which will connect
 to
> DB2 database and takes some data and insert into sql server database.  How
> can I do this.
>
> I saw the properties of receive location, where we can use them to schedul
e
> the receive port.  But here, Biztalk has to start automatically without an
y
> receive message (in this orchestration there won't be any input message to
> the .NET assembly).  How can I implement this.
>
> Please help.
I would not use an orchestration as your scheduler.
I would either use the windows scheduler, any other scheduling tool out
there or  develop a windows service to do the scheduling.

then have the orchestration started from this scheduler and do the work.

I think I saw out there once a scheduling adapter which is a nice idea.
have a look at gotdotnet

Yossi Dahan

[ Post a follow-up to this message ]

Thanks Yossi,

Any one with any other idea.....

"Yossi Dahan" wrote:

> Help Needed wrote: 
> I would not use an orchestration as your scheduler.
> I would either use the windows scheduler, any other scheduling tool out
> there or  develop a windows service to do the scheduling.
>
> then have the orchestration started from this scheduler and do the work.
>
> I think I saw out there once a scheduling adapter which is a nice idea.
> have a look at gotdotnet
>
> Yossi Dahan
>

[ Post a follow-up to this message ]

Use Windows Task Scheduler to copy some activation file to a FILE Receive
Location which kicks off your orchestration.

-Dave Stucki

[ Post a follow-up to this message ]