Field Descriptions

Table Information

FAQs

Costpoint Web Jobs

What can I do in this subtask?

Use the Costpoint Web Jobs table window screen to view the details of each Costpoint web job, including the application, submitting user ID, status, execution method, start and end date/time, detailed status, progress, company, cancelled by user ID, report name and status, action name, and whether the job is restartable.

Within this table window, two additional subtask links, Restartable Job Details and Scheduled Job History, are available to view additional job information:

When should I use this subtask?

All users can monitor these screens whenever there is a need to view the details of the job server workload.

System administrators can purge status information stored in the W_APP_STATUS_INFO table whenever desired.  

Since a new row is added to this table for each action and report executed on the server, this table can quickly become very large.

 

These screens can be used to view the execution status of any job submitted to the server.  These are the only screens in the current release of Costpoint web in which there is functionality for users to check on the status of jobs submitted asynchronously.

FAQs

What is the difference between "synchronous" and "asynchronous" processing?

In Costpoint client/server, most functions are implemented synchronously, in which steps are performed in a specific order and only after the previous step has successfully completed.  This means that you cannot execute another process or report on a real-time basis if another long-running process or report is currently in process (except in Report Preview mode).  The solution for this limitation in Costpoint client/server is to schedule the execution of longer-running processes and reports on a Process server.

In Costpoint web, for most functions you can choose either a synchronous mode of execution (the default) or an asynchronous (batch mode).  In a batch (asynchronous)mode, applications are unlocked almost immediately after submission of a report or process.  This means that you can submit a request for another report or process (including closing the application and shutting down the PC) before the current job is complete.

Note:  Some reports can only be executed synchronously in Costpoint web, as in a posting report, which must be successfully generated before the application will allow you to post.  Executing such a report asynchronously adds little value, since you must still keep the application open and wait for the report to finish before posting.

Action/report locking rules still apply.  For example, if you begin a single user process or report asynchronously, you cannot initiate another process until the first one completes, even though the application is unlocked.

Please refer to the following technical topics for more specific information:

Field Descriptions

Use the fields in this screen to view the details of each Costpoint web job, including the application, submitting user ID, status, execution method, start and end date/time, detailed status, progress, company, cancelled by user ID, report name and status, action name, and whether the job is restartable.

Application

The application ID displays in this non-editable field.

Application Name

The application name displays in this non-editable field.

You can click on the Notes icon at the end of the field, if necessary, to easily view extensive application name data without the need to use the Up arrow and Down arrow function keys within the field.

Submitting User

The submitting user ID displays in this non-editable field.

Status

The job status ("All," "Active," "Completed, " "Failed," "Cancel Requested," or "User Cancelled") displays in this non-editable field.

Execution Method

The execution method ("All," "Asynchronous," "Process Server," and "Synchronous"" displays in this non-editable field.

Note:  Although "API" and "Asynchronous API" also display in the drop-down box when you make your filter selections, these choices are not available in the current Costpoint web release.

Started Date/Time

The date and time that the application started on the server displays in this non-editable field.

End Date/Time

The date and time that the application ended on the server displays in this non-editable field.

Detailed Status

The detailed status of the application displays in this non-editable field.

Examples of detailed status messages include the following:

You can click on the Notes icon at the end of the field, if necessary, to easily view extensive detailed status data without the need to use the Up arrow and Down arrow function keys within the field.

Progress

The progress percentage towards completion (from the "Progress Meter" that monitors the real-time job completion on the screen) displays in this non-editable field.  

Company

The company ID displays in this non-editable field.

Cancelled By

If the job was cancelled, the ID of the user who cancelled the job displays in this non-editable field.

Report Name

The report name, as applicable, displays in this non-editable field.

You can click on the Notes icon at the end of the field, if necessary, to easily view extensive detailed report name data without the need to use the Up arrow and Down arrow function keys within the field.

Report Status

The report status displays in this non-editable field.

Examples of status messages include the following:

You can click on the Notes icon at the end of the field, if necessary, to easily view extensive detailed status data without the need to use the Up Arrow and Down Arrow function keys within the field.

Action Name

The action name, as applicable, displays in this non-editable field.

You can click on the Notes icon at the end of the field, if necessary, to easily view extensive detailed report name data without the need to use the Up Arrow and Down Arrow function keys within the field.

Restartable Job

If this job is restartable, "Y" displays in this non-editable field.

If this job is not restartable, "N" displays in this non-editable field.

Purge Displayed Rows

Click on this pushbutton to purge the data displayed in the table window.

The purge process will delete ALL rows that have been loaded into the table window, whether visible in the first 6 rows or not.  [In other words, all data for which the filter conditions are valid will be deleted from the database.]  The purged data is not written to any system table.

System administrators can purge status information whenever desired.  

Since a new row is added to this table for each action and report executed on the server, the W_APP_STATUS_INFO table can quickly become very large.

* A red asterisk denotes a required field.

Restartable Job Details

Click on this subtask link to open the Restartable Job Details subtask screen.

Scheduled Job History

Click on this subtask link to open the Scheduled Job History subtask screen.

Table Information

This screen accesses and displays data from the W_APP_STATUS_INFO (Web Application Status Information) table.

 

Top of Page