skills.rest
ajshedivy
ajshedivyCOMMUNITY
Explore all skills by this author →
GitHub

work-management

Query and monitor IBM i jobs via SQL services.

3|1|Updated Feb 3, 2026
Search Tags:#performance#monitoring#sql#work-management#jobs#ibmi#lock-analysis
One-click install
npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill work-management
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: work-management
Source: https://github.com/ajshedivy/ibmi-agent-skills/tree/main/skills/work-management
Command: npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill work-management

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

IBM i administrators and developers need a unified, SQL-based mechanism to discover, monitor, and diagnose work-management tasks across jobs, eliminating reliance on ad-hoc CL commands.

Core Features & Use Cases

  • Job discovery and filtering by status, user, type, and subsystem
  • Real-time performance monitoring (CPU, I/O, memory) and queue status
  • SQL activity and lock contention analysis
  • Replacements for WRKACTJOB, WRKUSRJOB, WRKSBSJOB, and WRKSBMJOB
  • Ad-hoc reporting and operational insights for scheduling and job logs

Quick Start

Install and start by querying active IBM i jobs and, if needed, request detailed info for a specific job.

Frequently Asked Questions about work-management

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I monitor IBM i active jobs using SQL instead of WRKACTJOB?▼

You can monitor IBM i active jobs using SQL by querying the QSYS2.ACTIVE_JOB_INFO service to retrieve real-time CPU, I/O, and memory performance metrics, replacing traditional WRKACTJOB commands for operational insights.

What is the best way to analyze lock contention on IBM i jobs?▼

Analyzing lock contention on IBM i jobs is done through SQL services that detect lock issues and long-running SQL activity, allowing you to diagnose bottlenecks without relying on ad-hoc CL commands.

Can I filter IBM i jobs by subsystem, user, or status using SQL?▼

Yes, you can filter IBM i jobs by subsystem, user, status, and type using SQL queries against QSYS2.JOB_INFO, providing a unified discovery mechanism to replace WRKUSRJOB and WRKSBSJOB workflows.

How do I query job queues and scheduled jobs on IBM i?▼

Querying job queues and scheduled jobs on IBM i is achieved through SQL services that review queue statuses and scheduling details, enabling ad-hoc reporting and operational insights without traditional CL commands.

Do I need the ibmi CLI to run SQL work-management queries?▼

Yes, running SQL work-management queries requires the ibmi CLI to access QSYS2.JOB_INFO and QSYS2.ACTIVE_JOB_INFO services, and the Skill is designed to be activated within Skill environments.

Related Skills

Explore More Data & Analytics Skills→
ajshedivyajshedivy
3

database-utility

Inventory and analyze IBM i database files using SQL services via ibmi CLI.

Community
Advanced
openeuler-mirroropeneuler-mirror
3

flamegraph-analysis

Analyze perf, pprof, and cpuprofile data to identify CPU hotspots and bottlenecks.

Official
Advanced
ajshedivyajshedivy
3

performance

Collect and analyze IBM i performance metrics via SQL services.

Community
Intermediate
ProfoundLogicProfoundLogic

ibmi-clcmd

Execute IBM i Control Language commands on remote systems via SSH.

Official
Basic