Install jobs with CCC

Prerequisites

Before installing jobs through CCC you need to go through the steps described in
Setting up a CCC node

Overview

The `jobs.script` is used to install or uninstall a specific job on a database instance managed by dbWatch Control Center. The script uses a query to identify the instance and performs the job operation accordingly.

Required Inputs

The script accepts the following parameters:

accesspoint – The address of the server node (host:port), default is `localhost:7100`
domainName – (Optional) Name of the domain to join
domainToken – (Optional) If the domain requires a token
node – The display name of this CCC node
instanceName – The name of the target instance to install the job on
job – The name of the job to install
mode – Operation mode: use `“install”` to install the job or `“uninstall”` to uninstall it

Example Command

./ccc.sh jobs.script accesspoint=localhost:7100 domainName=mydomain.local node=ccc01 instanceName=prod-db01 job=oracle_instance_overview mode=install

This will install the job named `oracle_instance_overview` on the instance `prod-db01`.

Example Output

If successful, the script will produce output similar to the following:

Joining domain mydomain.local
Connected to domain controller...
Executing job command...
Job oracle_instance_overview installed on instance prod-db01

Notes

The script uses the query: `instance[name=’{$instanceName$}’]` to locate the correct instance.
You can find available job names by inspecting the dbWatch Monitor interface or consulting documentation for your database platform.
Make sure the CCC node has the correct privileges to execute job installation. For minimum required privileges, refer to the Privileges and Actions Map