OE database as a service on Windows - Forum - OpenEdge RDBMS - Progress Community

OE database as a service on Windows

 Forum

OE database as a service on Windows

This question is not answered

Hello all,

Has anybody successfully configured a database to be started as a Windows service ? I think  it could be possible to do that with nssm or srvany, but I wanted to know if anybody had already done that and would like to share his findings.

Gilles

All Replies
  • Hi Gilles

    does this kbase help ? community.progress.com/.../30697

    Regards

    Laurent KIEFFER
    Senior Solution Consultant

    PROGRESS SOFTWARE FRANCE

    DIRECT       +33 (0) 4 72 38 52 11 
    MOBILE       +33 (0) 6 15 19 95 95

  • Sorry this one

    knowledgebase.progress.com/.../P46267

    Laurent KIEFFER
    Senior Solution Consultant

    PROGRESS SOFTWARE FRANCE

    DIRECT       +33 (0) 4 72 38 52 11 
    MOBILE       +33 (0) 6 15 19 95 95

  • The second solution is more or less what I'm looking for, but it doesn't handle the DB shutdown for example.

  • you could set up a scheduled task that starts the server (via a .bat script) after system boot

  • be careful with scheduled tasks on Windows. The default priority is "WINDOWS_YOU_GET_NO_CPU_AT_ALL_PRIORITY" for scheduled tasks and there is no way to change it in the UI. You need to export the task, manually edit the XML file, then reimport the task.

    Paul

    Paul Koufalis
    White Star Software

    pk@wss.com
    @oeDBA (https://twitter.com/oeDBA)

    ProTop: The #1 Free OpenEdge DB Monitoring Tool
    http://protop.wss.com
  • How about Windows startup/shutdown script configured in:

    1. Run gpedit.msc (Local Policies)

    2. Computer Configuration -> Windows Settings -> Scripts -> Startup or Shutdown -> Properties -> Add

  • thanks, wasn't aware of that, I found more info in

    stackoverflow.com/.../is-there-any-way-for-a-win2k8-scheduled-task-to-have-normal-priority-io