Specify Script - Table Dropped

 

Use this dialog box to specify a script to run when a table is dropped.

Field Name

Description

Script Name

Enter the name of the script.

Where to Run

Select the Agent where you want the script to run from the drop-down list.

Script Parameters

This section displays what parameters will be passed to the script when it is run. The parameters will be passed in the order specified.

 

  • <table> - The name of the table that triggered the alert condition.  

  • <computer> - The name of the computer where the triggering condition occurred.

  • <rdbms-type> - The type of RDBMS where the triggering condition occurred (for example, Oracle, SQL Server, Sybase, or UDB).

  • <rdbms-instance-name> - Oracle SID, SQL Server server name, Sybase server name, or DB2 Instance name.

  • <database> - The name of the database where the triggering condition occurred.

 

 

To learn more, see Running Scripts in Response to an Alert.