ManageEngine® SQLDBManager Plus
SQL Job Action
This action can be used to start/stop/restart SQL Jobs in the event of an alarm. To create an SQL Job action, follow the steps given below:
Select SQL Jobs from selected resources: The window displays a list of SQL servers that is currently monitored by SQLDBManager Plus. Select the SQL Server from the respective drop-down boxes, and click Show Job link.
This will list all the SQL Jobs. You can choose the SQL Job you want to add from this list. You can also add a new Job right from this window by clicking on 'Add Job' button.
Auto-select Servers: This option will automatically detect and trigger SQL Jobs action based on the associated monitor. For example, if the action is associated with a particular SQL server, the action will be triggered for that particular SQL server.
Selected Servers: This option lets you specify the exact SQL servers on which the action will be triggered. You can select the servers from the ones listed.
All Servers in the Selected Monitor Group: This option lets you specify the exact SQL servers on which the action will be triggered. You can select the SQL servers from the ones listed.
After creating the SQL Job action, you can test its execution by clicking the Execute icon .
Executing Query Action
Windows Services Action