Home : Products : OPS SQL : OPSSQL Service Bouncer - Installation and Configuration
Q10075 - HOWTO: OPSSQL Service Bouncer - Installation and Configuration

You will need local administrator priviledges to perform tasks described in this document.

  1. Download service_bouncer_install.exe
  2. Run service_bouncer_install.exe

  3. Select path to where OPSSQL is installed and click Finish.

  4. Navigate to the directory where Service Bouncer was extracted.

  5. Double Click on service_bouncer.ini file to open it in NotePad

  6. You will first need to configure which database platform you are using
    use DBTYPE=1 for Oracle Platform, and DBTYPE=2 for MSSQL
  7. Now specify the database/database server name in the Data Source field for the proper connection string
  8. Go to your NT Services console to look up names of NT services you are wanting to restart automatically

  9. In the ini file, specify the correct NT service names. You can add as many NT services as you need.
  10. Save changes to the ini file.
  11. For the purposes of this example, we will assume that the database goes down for cold backup at 12:01 AM every Sunday
    We will need to set a a scheduled task to fire service_bouncer.exe at that time.
  12. Go to Control Panel

  13. Go to Scheduled Tasks

  14. Select Add Scheduled Task

  15. In the wizard, Browse for a program
  16. Find and select service_bouncer.exe

  17. Select Weekly and click Next

  18. Select the appropriate time and day. Click Next

  19. You will be asked to provide an user that this task is going to use. Make sure the user you provide here is a local administrator. Then click Next.
  20. Hit Finish


You have configured  service_bouncer.exe to fire on a scheduled basis. Upon firing, service_bouncer.exe will STOP all services enumerated in its INI file. Then it will continously attempt to connect to the database. Once it has sucessfully connected (the database came back online), service_bouncer will START all services enumerated in its INI file.

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
This utility is just what we need. thank you! Approved: 12/2/2004 8:40 AM
Created on 12/1/2004 4:08 PM.
Last Modified on 9/18/2007 5:40 PM.
Last Modified by No Author Name Available!.
Article has been viewed 6375 times.
Rated 5 out of 10 based on 5 votes.
Print Article
Email Article