AMTrigger.Type

Syntax

%AMTrigger.Type%

Text (options)

Returns the database event type that activated the trigger. This value varies depending on the type of database being monitored:

Database	Description
SQL	If monitoring a SQL database, describes the different notification types that can be received: Change - Data on the server being monitored changed. Subscribe - There was a failure to create a notification subscription. Unknown - Used when the type option sent by the server was not recognized by the client.
ORACLE	If monitoring an Oracle database, returns the database event type for the notification: Change - A change occurred in the database. Subscribe - A change occurred in the subscription. Query - A query-based change occurred in the database.

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 type of database that activated the trigger - %AMTrigger.Type%" in a dialog.

Copy

<AMSHOWDIALOG WINDOWTITLE="Database Trigger Return Value">The type of database that activated the trigger - %AMTrigger.Type%</AMSHOWDIALOG>