Db Maint

Quick Start

Use this guide to get started with Db Maint.

1. Go though Server properties

It is a good idea to check the settings in server properties before you start creating your jobs and tasks.

2. Create e-mail operators if desired (Server properties).

Requires that you have configured SQL Server for e-mail support.

This can also be done with SQL Enterprise Manager.

Please refer to the Server properties section for more details.

3. Create Database Group(s) if desired.

Database group gives you the possibility to define similar job for several databases.

Please refer to the Database Groups section for more details.

4. Create Job(s).

A job defines what to perform for the database(s).

Please refer to the Jobs section for more details.

5. Create task(s).

The task defines when to perform job(s).

Please refer to the Tasks section for more details.

6. Make sure that the SQL Server Agent service is started

SQL Server Agent is the service that will execute the Db Maint server at defined schedule.