I need to periodically run an application on the server machine and feed it with parameter stored in the DB. Is there anything wrong with using server-side scheduled events to start an external application ?

On 5/28/2021 4:36 AM, Norman Rorke wrote:
> I need to periodically run an application on the server machine and feed it with parameter stored in the DB. Is there anything wrong with using server-side scheduled events to start an external application ?

Can't think of anything wrong about this.

Small downside IMHO is that if you need make changes you need to
recompile a new dbsrvr and deploy it.

Making server side event logic generic might help but if you're writing
delphi code anyways i would simply write a standalone utility to do what
you need and run thru windows task scheduler.

Raul

Raul wrote:

On 5/28/2021 4:36 AM, Norman Rorke wrote:
> I need to periodically run an application on the server machine and feed it with parameter stored in the DB. Is there anything wrong with using server-side scheduled events to start an external application ?

Can't think of anything wrong about this.

Small downside IMHO is that if you need make changes you need to
recompile a new dbsrvr and deploy it.

Making server side event logic generic might help but if you're writing
delphi code anyways i would simply write a standalone utility to do what
you need and run thru windows task scheduler.

Raul

Thanks for your input Raul.
As i mentioned, I need to feed the external app with parameters sourced from the DB. So a windows scheduled task would not work, and I have no issues with recompiling dbsrvr.

On 5/29/2021 6:33 PM, Norman Rorke wrote:
> Thanks for your input Raul.
> As i mentioned, I need to feed the external app with parameters sourced from the DB. So a windows scheduled task would not work, and I have no issues with recompiling dbsrvr.

Sounds good - choose what best works for you.

Just noting that unless those params are pure runtime ones (i.e. not
stored in db) the utility can trivially have same DB table access as
server.

Raul

Norman,

<< I need to periodically run an application on the server machine and feed it with parameter stored in the DB. Is there anything wrong with using server-side scheduled events to start an external application ? >>

No, we use this technique here in our build system.  The nice thing about the scheduled events is that they can be abstracted so that you can call the same code in both a scheduled event (automated builds on a schedule)  or a server-side procedure (automated builds triggered by an external call).

Tim Young
Elevate Software
www.elevatesoft.com