AMTrigger.Type

Related Topics

Syntax

%AMTrigger.Type%

Trigger/Condition Supported

Database

Type

Text (options)

Description

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.

Example

NOTE:
  • The sample AML code below can be copied and pasted directly into the Steps Panel of the Task Builder.
  • Parameters containing user credentials, files, file paths, and/or other information specific to the task must be customized before the sample code can run successfully.

This example displays the message "The type of database that activated the trigger - %AMTrigger.Type%" in a dialog box.

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