AMTrigger.Source

Syntax

%AMTrigger.Source%

Trigger/Condition Supported

Database

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 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 is altered and a new row is inserted into the same table, this property is set to either Object or Data. The following lists other possible return values:
    • Data - Specifies data- related events (for example, Insert, Delete, Update).
    • Database - Specifies database-related events (for example, Shutdown, Startup, Shutdown_Any, Dropped).
    • Object - Specifies object- related events (for example, Altered, Dropped).
    • Subscription - Specifies subscription-related events (for example, subscription end).

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.

The following displays the message The database that was monitored to activate the trigger - %AMTrigger.Source%:

Copy 
<AMSHOWDIALOG WINDOWTITLE="Database Trigger Return Value">The database that was monitored to activate the trigger - %AMTrigger.Source%</AMSHOWDIALOG>

Related Topics