Use the GET_STATISTIC_DETAIL script function to retrieve a detail from the execution data of an object. Execution lists store a broad range of data on executed objects. For more information, see Execution Data.
Note: You need authorization (S) to access the execution data of the given object to execute this script function. For more information, see Granting Automation Engine Authorizations.
GET_STATISTIC_DETAIL ([RunID] , Detail [, Object name])
Retrieves execution data of an object
(Optional) RunID of the execution
Format: script variable or number
Information to retrieve from the execution data
Format: AE name, script literal, or script variable
(Optional) Name of the object for which to retrieve execution data
Format: script literal or script variable
GET_STATISTIC_DETAIL returns a detail from the list of execution data depending on the parameters that you specify:
- RunID and Detail (and optionally the Object name): returns the detail from the specified run of a particular object
- Detail and Object name: returns the detail from the latest run of the specified object
only: returns the detail from the current execution data for the object that calls the script function
Note: The script cannot return values for certain details such as the runtime for the current execution, because the object is being executed.
Important! The following default values are returned when the specified detail is not available at the time of the script execution:
- For strings: an empty string
- For numbers: 0
- For date and time stamps: 0000-00-00 00:00:00
- What looks like a default value may be the actual value that is retrieved from the execution data, such as a return code of 0.
- The script function returns numbers in a 16-digit format by default, including floating-point numbers (data type: float). Zeros are inserted in places that are not used. For more information, see Script Variable Data Types.
Tip: Use the FORMAT script function to remove leading or final zeros.
- The script does not abort when no execution data is found and the script function returns an empty string.
Tip: Use the :ON_ERROR script statement to define actions to take.
All Object Types
The following details from the execution data are available for all types of executable objects.
Archive key 1
Archive key 2
Alias of the executable object
Name of the object
Type of the object
Name of the user (NAME/DEPARTMENT)
User time used
Activation and Execution Details
Time of the activation in YYYY-MM-DD HH:MM:SS format
Indicates whether the task was canceled
- An empty string
The task was not canceled
The task was canceled
- An empty string
Runtime in seconds
End time of the object in YYYY-MM-DD HH:MM:SS format
Error message of the last error that occurred
Error number of the last error that occurred
Logical date in YYYY-MM-DD HH:MM:SS format
Number of modifications to the object
Start time of the Post Process in YYYY-MM-DD HH:MM:SS format
RunID of the selected execution data
Start time of the object in YYYY-MM-DD HH:MM:SS format
Status of the execution
For more information on system return codes, see System Return Codes of Executable Objects.
Last passed restart point
Reference RunID in a restart
Indicates whether the execution is a restart
The execution is a restart
The execution is not a restart
Restart point for the task
Information about Parent Tasks and Activators
RunID of the activator of the task
More information: Superordinate Tasks (Parents)
RunID of the parent task when the parent is a processor (Workflow
, Schedule or Group)
The following details from the execution data are available for Event objects only.
(Event objects only) Number of checks made
First RunID of File System and Console events
Number of events that have occurred
File Transfer Objects
The following details from the execution data are available for File Transfer objects only.
- An empty string
Name of the destination code table
File attributes for the destination file
Name of the destination file
Name of the destination agent
Host type of the destination agent
Complete login information of the destination Login object of the File Transfer
Name of the destination Login object
Number of bytes used by the transferred file
(Text file transfers only) Number of transferred lines or records
Note: If the transferred file is a binary file, the return code is 0.
Name of the source code table
File attributes of the source file
Name of the source file
Name of the source agent
Host type of the source agent
Complete login information of the source Login object of the File Transfer
Name of the source Login object
Number of transferred bytes
The following details relate to the consumed resources for the run, and are available for Job objects only.
The CPU time used
Number of I/Os
Kernel time used
The following example in a File Transfer object reads the name of the file to transfer from the current execution data.
:SET &SOURCE_FILE# = GET_STATISTIC_DETAIL(,SRC_FILE_NAME)
The following example reads the start time of the parent task:
:SET &NAME# = SYS_ACT_PARENT_NAME()
:SET &START# = GET_STATISTIC_DETAIL(,START_TIME, &NAME#)
The following example retrieves the activation time of an object that is called MM.DAY:
:SET &RUNNR# = GET_UC_OBJECT_NR("MM.DAY")
:SET &ACTIVATION# = GET_STATISTIC_DETAIL(&RUNNR#, ACTIVATION_TIME)
The following example reads and prints the alias of the executable object in the activation report.
:SET &ALIAS# = GET_STATISTIC_DETAIL(&RUNID#,ALIAS)