You can write a shell script and configure an alert to execute the script.
Use scripts to help manage and respond to alerts. A script might trigger a visual alarm in a control center or send an e-mail message about the alert to a list of addresses (a way of supplementing the alert subscription feature, which accepts a single address).
When you configure an alert to execute a script, you:
- Specify the states or thresholds that set off the alert
- Specify the severity level that triggers execution of the script
- Supply an execution parameter string to be passed to the script
Scripts are executed under the login account used to start Sybase Control Center. Make sure that account has permissions that allow it to perform the actions contained in all scripts.
When a script executes, Sybase Control Center logs the start time, end time, and status and exit codes to the alert services log. Log location:
In a standard installation:
SCC-3_2\log\alert-server.log
In a shared disk installation:
SCC-3_2\instances\<instance-name>\log\alert-server.log
Warning! Use caution in writing scripts. A poorly designed script can cause a blocking situation, creating a deadlock in your Sybase Control Center server.