AMTrigger.Source
Syntax
%AMTrigger.Source%
Trigger/Condition Supported
Type
String
Description
Returns the database event source that activated the trigger. This value varies depending on the type of database being monitored:
Database | Description |
---|---|
SQL | If monitoring a SQL database, the return value indicates the source that initially activated the trigger, such as a change to the query data or the database’s state. |
ORACLE | If monitoring an Oracle database,
the return value can be an enumeration related to the database
event source. For example, if a table has been altered and a new
row has been inserted into the same table, this property is set
to either Object or Data. Below lists other possible
return values:
|
Example
NOTE:
- Copy and paste the sample AML code below directly into the Task Builder Steps Panel.
- To successfully run the sample code, update parameters containing user credentials, files, file paths, or other information specific to the task to match your environment.
This example displays the message "The database that was monitored to activate the trigger - %AMTrigger.Source%" in a dialog.
Copy
<AMSHOWDIALOG WINDOWTITLE="Database Trigger Return Value">The database that was monitored to activate the trigger - %AMTrigger.Source%</AMSHOWDIALOG>