requestqueue

The RequestQueue table contains one entry for each request which has been successfully scheduled (this requires successful compilation in the case of a scripted request). The scheduler pools this table for requests to execute.

Column Name Column Datatype Column Null Option Column Comment
requestid integer not null The ID from the Request table of the request.

serverid integer not null The ID from the LookOutServer table of the Script Manager server to execute this request. If no server is specified, this value is 0, and a server must lock this row to execute the request by setting this field to it’s ServerId value.
nextexecutiontime date not null The Datetime when this request should next be executed.
userid integer not null The ID of the user who scheduled the request.
reschedule integer1 not null The ID of the request to schedule. Used in Infopump 3.0 command line version.
locktime date with null The Datetime when server lock was obtained.

Product Name: Data Transformer

Table Type: Table


Copyright © 2006 CA. All rights reserved.