Create Tasks to Cycle Eaglesoft DB Services

Must be Ran at Least Once a Week

Eaglesoft can run into problems if the database is not shut down and restarted on a regular basis. This should occur at least weekly in order to avoid backup times.

Note:  This is based off of official documentation from Patterson Eaglesoft. However, those instructions were modified by our technician to better suit our needs, which include limiting downtime of the service so it would not cause alarms within PRTG monitoring.  

Prerequisite

“Automated Client Disconnection” 

1. Click Start > Programs > Eaglesoft > Technical Reference
2. Click Database Setup
3. Check the box for “Disconnect active clients when shutting down the server.”
4. Select OK, then click Yes to accept the changes.

Task 1

“Eaglesoft Stop Database”

Important: Use this name exactly* 

1. Use Create a Basic Task Wizard
2. Set the name to “Eaglesoft Stop Database.” Add a description if you’d like.
3. Set the recurrence of the event.
4. Adjust the start time for the event to a point after the office has closed for the day but before the automated backup is scheduled to run.
5. Leave the action set to “Start a program.”
6. In the “Program/script” box, enter:

“C:\Eaglesoft\SharedFiles\PattersonServerStatus.exe”

In the “Add arguments” box, enter:       -stop

7. Check the box for “Open the Properties dialog…” and click Finish.
8. Set the radio button on the General tab to “Run whether user is logged on or not”
9. Check the box for “Run with highest privileges”.
10. Click OK and provide the login credentials for a high-level user account (e.g., Administrator or an administrator-level account).

Task 2

“Eaglesoft Start Database” 

1. Use Create a Basic Task Wizard
2. Set the name to “Eaglesoft Start Database”. Add a description if you want.
3. Pick any recurrence and start-time of the event. THIS WILL BE CHANGED LATER.
4. Leave the Action set to “Start a program”.
5. In the “Program/script” box, enter:              NET

In the “Add arguments” box, enter:     STOP “PattersonServerStatus”

6. Check the box for “Open the Properties dialog…” and click Finish.
7. Set the radio button on the General tab to “Run whether user is logged on or not”
8. Check the box for “Run with highest privileges”.
9. On the “Triggers” tab, select “Delay task for:” and set to 1 minute.
10. Change the trigger from “On a schedule” to “On an event”, select “Custom”, and click on “Edit Event Filter”.
11. Select “Edit query manually” and then paste the following:

 

   *[EventData[@Name=’TaskSuccessEvent’][Data[@Name=’TaskName’]=’\Eaglesoft Stop Database’]]

 

 

12. Click OK and go back to the “Actions” tab.
13. Click “New” (to add a 2^ndaction) and leave the action set to “Start a program”.
14. In the “Program/script” box, enter:              “C:\Eaglesoft\Shared Files\PattersonServerStatus.exe”

In the “Add arguments” box, enter:     -start

15. Click OK, ensure this new task is below the original NET STOP, and go back to the “Settings” tab.
16. Change “Stop the task if it runs longer than:” to 1 hour.
17. Change “If the task is already running” drop-down to “Stop the existing instance”.
18. Click OK and provide the login credentials for a high-level user account (e.g., Administrator or an administrator-level account).