Database Event Attributes
This topic provides the list of attributes that apply to Database Event objects. First, the view on the UI on which you find the corresponding fiels is indicated. Below each view, the fields on the UI are listed. Below each field you find the correponding attribute with its value, length and way of accessing.
You can use predefined variables in Scripts. Script variables can be set to attributes retrieved via predefined variables
Database Page
Value 1 - Source
OPERAND1_SOURCE
Value:
- SQL (SQL query)
- STATIC (Statistical value)
- VARA (VARA object)
Access through: GET_ATT, :PUT_ATT
Value 1 - SQL
OPERAND1_SQL_QUERY
Value: SQL statement
Length: Max. 4096 characters
Access through: GET_ATT, :PUT_ATT
Value 1 - Server
OPERAND1_SQL_SERVER_NAME
Value: Name of the database computer
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Value 1 - Agent
OPERAND1_SQL_AGENT
Value: Name of a database Agent
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Value 1 - Database
OPERAND1_SQL_DATABASE_NAME
Value: Database name
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Value 1 - Login
OPERAND1_SQL_LOGIN
Value: Name of the Login object
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Value 1 - MS Access only: File name
OPERAND1_MSACCESS_FILE
Value: Path and file name of the MS Access database
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Value 1 - Static value
OPERAND1_STATIC_VALUE
Value: Static value
Length: Max. 255 characters
Access through: GET_ATT, :PUT_ATT
Value 1 - Variable object
OPERAND1_VARA_NAME
Value: Name of a VARA object
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Value 1 - Variable Key
OPERAND1_VARA_KEYWORD
Value: Name of a key
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Operator
OPERATOR
Value:
- >
- <
- =
- <>
- >=
- <=
- contains
Access through: GET_ATT, :PUT_ATT
Value 2 - Source
OPERAND2_SOURCE
Value:
- SQL (SQL query)
- STATIC (Statistical value)
- VARA (VARA object)
Access through: GET_ATT, :PUT_ATT
Value 2 - SQL
OPERAND2_SQL_QUERY
Value: SQL statement
Length: Max. 4096 characters
Access through: GET_ATT, :PUT_ATT
Value 2 - Server
OPERAND2_SQL_SERVER_NAME
Value: Name of the database computer
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Value 2 - Agent
OPERAND2_SQL_AGENT
Value: Name of a database Agent
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Value 2 - Database
OPERAND2_SQL_DATABASE_NAME
Value: Database name
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Value 2 - Login
OPERAND2_SQL_LOGIN
Value: Name of the Login object
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Value 2 - MS Access only: File name
OPERAND2_MSACCESS_FILE
Value: Path and file name of the MS Access database
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Value 2 - Static value
OPERAND2_STATIC_VALUE
Value: Static value
Length: Max. 255 characters
Access through: GET_ATT, :PUT_ATT
Value 2 - Variable object
OPERAND2_VARA_NAME
Value: Name of a VARA object
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Value 2 - Variable Key
OPERAND2_VARA_KEYWORD
Value: Name of a key
Length: Max. 200 characters
Access through: GET_ATT, :PUT_ATT
Time Parameters: Frequency
EVENT_REPEAT
Value:
- R (repeatedly)
- S (once, single run)
- F (repeat until first match)
Access through: GET_ATT, :PUT_ATT
Time Parameters: Check Frequency
EVENT_TIME
Value:
- MMMM (minutes in interval)
- HHMM (start time)
Access through: GET_ATT, :PUT_ATT
First check
EVENT_FIRST_EXEC
Value:
- N (after first interval)
- S (immediately))
Access through: GET_ATT, :PUT_ATT
Start after check time (If start time is later)
EVENT_START_AFTER_SCH
Value: N (do not run) / Y
Access through: GET_ATT, :PUT_ATT
See also:
:PUT_ATT
GET_ATT