Long-Running Processes
Categories:
- Target Database: —
- Context Type: —
- Alert Severity: —
- Triggered Time: —
- Firing Context:
—
Long-Running Processes Alert
Alert ID: long_running_processes
Category: Process Scheduler
Default threshold: 20 minutes
What This Alert Detects
This alert finds Process Scheduler requests that are currently in Initiated or Processing status and have been running longer than the configured time threshold. A process that has been running for a long time may be stuck, consuming excessive server resources, or waiting on a lock or resource that will never become available.
Severity Logic
| Condition | Severity |
|---|---|
Running longer than thresholdMinutes | Warning |
For example, with the default threshold of 20 minutes:
- A process running for 25 minutes or more → Warning
What Gets Checked
The alert queries the Process Scheduler request table for processes in run status 6 (Initiated) or 7 (Processing). For each result, it calculates how long the process has been running based on its BeginDttm (begin datetime) and the current server time.
Processes with no BeginDttm value are skipped (the process hasn’t truly started yet).
Alert Details
Each alert item includes:
- Process name (
PRCSNAME) - Process instance number
- How long the process has been running (in minutes)
- The operator who submitted the request
- A link to the Process Monitor detail page for that instance
Configuration
alerts:
checks:
long_running_processes:
enabled: true
thresholdMinutes: 20 # Minutes before flagging as Warning
excludeProcesses: # Process names to skip
- SOME_LONG_BATCH_JOB
| Setting | Default | Description |
|---|---|---|
thresholdMinutes | 20 | Minutes a process must be running to trigger a Warning alert. |
excludeProcesses | [] | List of process names to exclude from this check. Use for known long-running processes that are expected to take a long time. |
How to Respond
- Click the alert link to go directly to the Process Monitor entry for the flagged process
- Review the process details: what it is, who submitted it, when it started
- Check whether the process appears to be making progress or is stuck
- If the process is genuinely stuck, you may need to cancel it from PeopleSoft’s Process Monitor
- Investigate why it got stuck: look for locks, resource contention, or data issues
Tuning the Threshold
The right threshold depends on your environment. If you have batch jobs that are expected to run for 30-60 minutes, set thresholdMinutes to something higher than your longest expected normal runtime. You can also use excludeProcesses to exclude specific jobs from the check rather than raising the threshold for everything.