Create a Database Runbook
Overview
Database Runbooks in Motadata AIOps are instrumental for executing specific actions on a database, such as performing queries, releasing memory, and executing various other database operations. Utilizing the JDBC protocol, the Database Runbook establishes a connection with the database to perform the specified actions securely and efficiently.
Navigation
Go to Menu, Select Settings 
. After that, Go to Plugin Library 
. Select Runbook. The Runbook screen is now displayed.
Select 
to start creating a Runbook. Select Database to create a Database Runbook.
Database Runbook Configuration
The Database Runbook creation screen presents various parameters to define the Runbook's functionality and assign it to monitors or groups. Below is a detailed breakdown of each parameter:
| Field | Description |
|---|---|
| Runbook Name | Assign a logical and unique name that identifies the task performed by the runbook. |
| Description | Provide a description of the Runbook. |
| Type | Select the type of database for which you are creating the runbook. |
| Monitor/Group/IP-Host | Select Monitor, Group, or IP/Host based on the device(s) to which you want to assign the runbook. |
| Select Monitor | Select desired monitor from the 'Monitors' dropdown if you want to assign the Runbook to an individual monitor. This option is available when you select Monitor in the previous field. |
| Select Group | Select desired group from the 'Groups' dropdown if you want to assign the Runbook to a group of monitors. This option is available when you select Group in the previous field. |
| Select IP/Host | Specify the IP/Host if you want to assign the Runbook to a device that is not discovered in Motadata AIOps as a Monitor. This option is available when you select IP/Host in the previous field. |
| Credential Profile | Select the credential profile from the dropdown to enable the Runbook to access and perform tasks on the monitor securely. |
| Create Credential Profile | Select this option if you need to create a new credential profile. |
| Port | Specify the port number in this field. In case you select a credential profile, the port number specified in the credential profile will be used. You can override the port number from the credential profile by specifying a port number in this field. |
| Timeout | Specify the timeout in this field. In case you select a credential profile, the timeout specified in the credential profile will be used. You can override the timeout from the credential profile by specifying a timeout in this field. |
| Log Collection | Enable this check-box to use the runbook for log collection. When you enable this field, the runbook will be available for selection while creating a log collection profile |
| Database Script | Write the script detailing the task that you wish to execute using the Runbook. |
| Script Language | Specify the language(Go or Python) you want use to write the parsing script. |
| Parsing Script | Write the script to parse the output derived post database script execution. |
| Add Variable | Add a variable if required in the parsing script. |
Click on Test option to validate the credential profile against the selected monitor.
Click on the Create Runbook Plugin to create the Runbook ensuring all parameters are defined as per your requirements. Note that this option becomes available only after successful testing.
Click on the Reset option to clear all input fields.