![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 5 of 5 total |
![]() |
Fri, May 28 2021 4:36 AM | Permanent Link |
Norman Rorke | 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 ?
|
Fri, May 28 2021 7:46 PM | Permanent Link |
Raul ![]() | 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 |
Sat, May 29 2021 6:33 PM | Permanent Link |
Norman Rorke | 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. |
Thu, Jun 3 2021 4:04 PM | Permanent Link |
Raul ![]() | 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 |
Wed, Aug 4 2021 6:55 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |