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. |
| Monitor/Group/IP-Host | Select Monitor, Group, IP/Host based on the device 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. |
| Select Group | Select desired group from the 'Groups' dropdown if you want to assign the Runbook to a group of monitors. |
| 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. |
| 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 | Enter the port number of the database instance. |
| Timeout | Specify the time (in seconds) that AIOps will attempt to establish a database connection before timing out. |
| SQL 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 SQL 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.