Managing Jobs

The Manage Jobs window in dbWatch Control Center provides a centralized interface for managing monitoring and maintenance jobs on database instances.

You can use this interface to install, reinstall, upgrade or uninstall jobs on individual instances or multiple instances.

Jobs can be managed individually or through job templates. Job templates allow you to maintain a common set of monitoring jobs and configurations across multiple database instances.

How to get here

To open Manage Jobs, select Server → Server Configuration → Manage Jobs from the dbWatch Client menu.

This opens the Manage Jobs window.

Selecting Database Instances

On the left side of the Manage Jobs window, you will find a tree containing the available database instances, organized by domain and group.

Select a database instance to display its available jobs.

The Filter field above the instance tree can be used to locate a specific instance or group.

Job Overview

The right side of the window displays the available monitoring and maintenance jobs for the selected instance.

Jobs are organized into categories, such as Capacity, making it easier to locate jobs related to a particular monitoring area.

There are two tabs:

You can expand individual jobs to inspect additional information and use the filter field to locate specific jobs.

The checkboxes allow you to select one or more jobs for the requested operation.

Managing Individual Jobs

The toolbar at the top of the Manage Jobs window contains four operations:

Installing Jobs

To install additional monitoring or maintenance jobs:

1. Select the database instance in the tree on the left.
2. Open the Custom tab.
3. Locate the jobs you want to install. Use the filter field if necessary.
4. Select the jobs using their checkboxes.
5. Click Install.

The installation process will install the selected jobs on the selected database instances.

The jobs available for installation may depend on the database type, license and monitoring configuration, including whether a local monitoring schema is installed.

Reinstalling Jobs

The Reinstall operation can be used to reinstall jobs that are already installed on a database instance.

1. Select the relevant database instance.
2. Select the installed jobs you want to reinstall.
3. Click Reinstall.

Before reinstalling a customized job, consider whether the operation may affect local modifications to the job configuration.

Upgrading Jobs

The Upgrade operation is used to update installed jobs when newer versions are available.

1. Select the relevant database instance.
2. Select the jobs you want to upgrade.
3. Click Upgrade.

Upgrading jobs is particularly useful after updating dbWatch Control Center, when newer job definitions may have been included in the software release.

Uninstalling Jobs

The Uninstall operation removes jobs from the selected database instances.

1. Select the relevant database instance.
2. Select the jobs you want to remove.
3. Click Uninstall.

Uninstalling a job stops the monitoring or maintenance functionality provided by that job. Make sure the job is no longer required before removing it.

Managing Jobs Using Templates

Job templates provide a way to define and maintain a common set of monitoring jobs across multiple database instances.

When adding a new database instance through the Instance Wizard, you can choose to install jobs based on a template or select individual jobs.

Templates can also be assigned or modified after the instance has been added to dbWatch Control Center.

The Templates tab in Manage Jobs provides access to template-based job management.

Assigning Templates Using Metadata

Job template assignments can be managed through Server → Server Configuration → Edit metadata.

The metadata properties jobtemplate and jobtemplatemode control which templates are assigned to an instance and how template synchronization handles jobs.

Depending on the template configuration, manually installed jobs or individual job configurations may be affected by subsequent template synchronization.

When managing jobs individually, check whether the instance is assigned to a job template. Template synchronization may affect manually installed or configured jobs, depending on the template mode.

The Edit metadata interface is particularly useful when you need to apply job changes to several database instances without configuring each instance separately.

For more information about configuring templates and template synchronization, see Job templates.

Manage Jobs Versus Instance Wizards

There are two main ways to install monitoring jobs on a database instance.