Process Monitoring Utility For MS-SQL is a workflow administration and process lifecycle management application that inspects active tasks, reassigns pending activities, recovers aborted workflows, and restarts completed processes on Microsoft SQL Server databases across Joget v4 to DX 7.

System administrators, workflow engineers, and database administrators struggle to manage stuck or misrouted process instances when handling complex enterprise workflows. Unhandled workflow exceptions lead to orphaned task assignments, incorrect user assignees, stuck process activities, and unrecoverable aborted workflows across business applications. Administrative teams require dedicated front-end monitoring portals built specifically for Microsoft SQL Server databases to reassign pending tasks, re-evaluate workflow assignments against updated process designs, and recover failed workflow instances.

Key Features

• Displays detailed process registries listing active, pending, and completed workflow instances alongside process IDs, process names, requesters, start times, and current states.
  
• Reassigns pending workflow tasks directly from user A to user B across active application activities.
  
• Re-evaluates active task assignments automatically based on published updated workflow process designs.
  
• Completes active process activities forcefully to advance stalled workflows through complex process paths.
  
• Aborts stuck or duplicate active workflow tasks to halt unnecessary process execution.
  
• Recovers aborted workflow processes to resume halted operational tasks from point of failure.
  
• Restarts completed workflow processes to re-execute closed process instances when business inputs change.
  
• Restricts administrative monitoring functions strictly to authenticated users possessing 'admin' user roles.
  
• Filters running activities and process histories by application name, process title, activity name, assignee, requester, and creation date ranges.
  
• Exports process execution logs, activity registries, and completed process records into CSV, Excel, XML, and PDF formats.

Frequently Asked Questions

Why is Process Monitoring Utility For MS-SQL designed specifically for Microsoft SQL Server databases?

Process Monitoring Utility For MS-SQL utilizes native database queries tailored to Microsoft SQL Server schema structures to execute process recovery, task reassignment, and state overrides directly against the Joget database engine.

Who can access and execute process actions within Process Monitoring Utility For MS-SQL?

Process Monitoring Utility For MS-SQL restricts access exclusively to users holding the 'admin' user role because executing process aborts, recoveries, completions, or restarts causes permanent database state changes that cannot be undone.

Which Joget platform versions support Process Monitoring Utility For MS-SQL?

Process Monitoring Utility For MS-SQL runs on Joget v4 to DX 7 platforms powered by Microsoft SQL Server databases.

Important Note: This Joget utility was designed for Microsoft SQL database only. Click here for MySQL database.

Learn more about workflow processes and activities from Joget User Guide.