Process Manager (MOOUSER)


Controls


Refreshes the window, updating the status of processes running, queued and completed. The Process Manager will also periodically refresh itself automatically.


Queue grid


The queue grid displays information about Processes.



The following table explains the data presented in the queue-grid.


Object

Description

Submitted

A unique ID that has been assigned to a specific Process.  

The unique ID is derived from POSIX time of submission.

This ID can be used when analyzing the Audit log MOOSERVER.SUBDATA.

Double click on this ID to displays details of the execution of a specific task, as shown below.

User

The user who submitted the process, this is not the database user, but the application user stored in EXPRESS$ME_USER

Process ID

The Process name (PR.ROW) that has been submitted for processing.

Process Description

A description of what the submitted process does.

Start Time

The date / time the process started.

Finish Time

The date / time the process completed.

Status

The Status: Queued, Started, Finished, Errored

Duration

The length of time the process took to complete.

Seq

The sequence (order (integer)) of jobs waiting to be processed.

AW

The name of the Oracle OLAP Analytic Workspace which the specified process or workflow is executing within

RO/RW

The mode; Read-only or Read-write for the specified process

Icon

Quick-glance, Queued [Pause Icon] Started [Play Icon], Completed Success [Tick Icon], Errored [Warning Icon], Unknown State [FinanceHub Icon]


For those columns with a drop down box (User, Program Description & Status) you can click on the drop down to open a menu. You can then select an option to display only the columns with the selected user, description and/or status.


Double clicking the Submitted column for a given process will bring up details on the process. Click the Back button to return to the Process Manager view.