In SAP systems, long-running transactions refer to business processes or activities that take a significant amount of time to complete. These transactions can have an impact on system performance and overall efficiency. If your SAP system is experiencing performance degradation, it may be due to the long-running job execution time that is caused by an expensive SQL statement. Other causes and side effects of long-running transactions can also show up in areas like waits, blocking, locks, memory bottlenecks, high process, and CPU utilization, and timeouts.
...
Getting started with monitoring expensive and long SAP SQL Statements is as simple as defining the recovery activity within the background job monitoring threshold override.
The first step is to download the functionality from and import IT-ConductorConduction function module in form of SAP Transport, this will enable batch job monitoring to in your SAP system and it will display the ABAP SQL Statement that is currently being executed when the runtime threshold is reached.
...
Navigate to the IT-Conductor main menu → Support → Downloads and download and import the following IT-Conductor SAP Transport into the target SAP System (v6.72 IT-Conductor Function Modules MS1K90492)
...
After importing the roleTransport, you have to define the recovery activity that for the job you want to monitor. In this case, let’s define a recovery activity for a background job.
Navigate to Target System → Background jobs, then click on the Background jobs Runtime gear icon → Override
...
You may choose to create an override from zero or create an override from a template
...
Give the alert override a descriptive name
On the object criteria, indicate the following
Elapsed Time
Target System (SID)
Job Name you wish to track
User who created Owner of the job
...
Set the threshold values and the alert message that will be displayed whenever the job elapsed time goes over the defined threshold. The message will display the objects selected on in the object criteria section.
Under the Recovery section, click on the drop-down arrow for Recovery activities and select the predefined recovery activity for background jobs.
...
Click on the Save icon
When an alert notification is generated for a long-running job is generated, a recovery action activity is will also be triggered.
Tracking In-Flight Time
You may track the time in which a background activity had gone over the previously established elapsed time as well.
...