Home : Ado Calc Queue
Q11023 - INFO: Ado Calc Queue

Displays the queue (backlog) of ADO Calc requests.

FIELDS:

ID: Unique ID of request

Status:  The status of the request.  Has the following values:

0 - Pending (Request submitted and the calling program does not require server reply when request is complete).  Typically, this status is seen when the calc request was submitted by an OPS SQL Interface or the GNR server.
1 - Pending (Client requested server reply upon completion).  Typically, this status is seen when the OPS SQL client requested the calculation. 
2 - Completed
999 - Currently being processed by ADO Calc.

Status_Desc: Description of Status, see above.

AuditUser: User that requested the calc.

AuditTimeStamp: Date/time request was made.

Facility:  The OPS SQL Facility calc request was made for.

VLIST: The list of variables that were requested to be calculated.  If blank or '0', request is for all variables to be calculated.

datestart: The start date of the date range to be calculated.  After the request is complete this field contains the date/time ADO Calc started processing the request.

dateend: The end date of the date range to be calculated.  After the request is complete this field contains the date/time ADO Calc finished processing the request.

BUTTONS:

Refreshes the list

Copies the records listed to the windows clipboard.

Outputs the list to the printer.

NOTE:

All calc request with a status of 2 (Completed) or 999 (Processing) are deleted from the queue when ADO Calc is restarted.

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 4/25/2008 1:53 PM.
Last Modified on 10/10/2008 12:01 PM.
Last Modified by Scott Dorner.
Article has been viewed 2667 times.
Rated 2 out of 10 based on 2 votes.
Print Article
Email Article