Alert variables for ordered jobs

The following table describes alert variables for ordered jobs.

Variable

Description

%%ALERT-APPLICATION-NAME

Defines the application that owns the alert.

%%ALERT-APPLICATION-ID

Defines the application ID.

%%ALERT-NAME

Defines the name of the alert.

%%ALERT-CHECK-DATE

Defines the time that the alert was raised in Oracle E-Business Suite system.

%%ALERT-CM_CONNECTION_PROFILE

Defines the Control-M for Oracle E-Business Suite connection profile name that represents Oracle E-Business Suite where the alert was monitored.

%%<OUTPUT name>_n

If the output variables exist as a result of the alert check, the following variables are added for each output:

<OUTPUT value as returned by the alert>

EXAMPLE: %%ORDER_ID_1 zzz

The maximum number of output variables that are added to the ordered job is set in the ALERT_MAX_OUTPUT parameter in event_cfg.dat file. The default is 20.

NOTE: The output variable contains the output of the SQL statement performed by the alert (the exceptions values). You can see the database information retrieved by the alert in the newly ordered job according to the output variables defined in the Oracle E-Business Suite alert.

Parent Topic

Creating an alert variable for a job