Support

dbOmnibus Installation

 

dbOmnibus is installed on each instance. It can be installed / updated to multiple servers at once using the Central Managed Servers (Registered Server) capabilities of SSMS.

dbOmnibus is currently running on many SQL Windows Virtual machine and Azure Managed Instances. It has not been tested by the developers on Linux or AWS.

Requirements

  1. dbOmnibus will work on SQL versions 2000 onward and with all editions*.
  2. A repository database called dbOmnibus is installed on each monitored server to store the data captured by the solution components.
  3. If alerts and other messages are to be sent by the monitored server, then DB Mail must be configured on each server. (This is optional, but recommended).

  4. If integration with Ola Hallengren’s solutions is used, see the related documentation.

 

Downloading

dbOmnibus is FREE and can be downloaded from our download page.

 

Installing

The dbOmnibus solution is designed in a way that allows it to be redeployed / updated over an existing installation without harm or data loss.
As newer versions are released, simply deploy it to an existing installation.

To install dbOmnibus:

  1. Create a database called dbOmnibus (this must be the database name)
  2. Open the dbOmnibus-Deploy.sql file
  3. Copy the entire contents of the deploy script to a SQL query tab in SSMS
  4. Execute the script

A single script will create all the necessary objects in the database including the SQL Agent jobs.

 

Configuring

Email

It is recommended to receive emails from each server if issues are detected. This is an optional feature.

  1. Ensure that email is configured on the SQL instance.
  2. Configure an email address in dbOmnibus with this script, enter the desired email address. (multiple address can be separated with ';'
    UPDATE [Lookup].[Configuration] SET [Value]=’MyEmail@null.com’ WHERE [Key]=1;

Agent Jobs

Three SQL Agent jobs are created by the deploy script. they must be enabled in order to run.

Enable each of the jobs:

dbOmnibus_Capture
dbOmnibus_CaptureDaily
dbOmnibus_Startup

 

Updating

To update dbOmnibus, run the dbOmnibus-Install.sql script (same script used to install). Follow the Installing steps listed above,

The upgrade process will not alter the configuration or job schedules. It will also preserve existing captured data.

 

Uninstall

To uninstall dbOmnibus, follow these steps:

1. Delete these 3 SQL Agent jobs:

dbOmnibus_Capture
dbOmnibus_CaptureDaily
dbOmnibus_Startup

2. Delete the DbOmnibus database.

That's it.

 

Page Last Updated: 20 August 2025