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