Specify Script - Total Table Size Greater Than

 

Use this dialog box to specify a script to run when the total size of a table is greater than a specified amount.

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, Sybase server, DB2 Instance name

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

  • <usage><size-designator> - Value of used disk space, in KB, MB, or GB.

  • <threshold><thr-designator> - Value of the triggering condition, in KB, MB, or GB, or % (value units).

 

 

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