Diagrams


Table

Job Queue Entry

Fields

# Name Type
1 ID GUID
2 User ID Text65 Editable: No
3 XML BLOB
4 Last Ready State DateTime Editable: No
5 Expiration Date/Time DateTime
6 Earliest Start Date/Time DateTime
7 Object Type to Run Option
8 Object ID to Run Integer
9 Object Caption to Run Text250 Editable: No
FlowField
10 Report Output Type Option
11 Maximum No. of Attempts to Run Integer
12 No. of Attempts to Run Integer Editable: No
13 Status Option Editable: No
14 Priority Integer
15 Record ID to Process RecordID
16 Parameter String Text250
17 Recurring Job Boolean
18 No. of Minutes between Runs Integer
19 Run on Mondays Boolean
20 Run on Tuesdays Boolean
21 Run on Wednesdays Boolean
22 Run on Thursdays Boolean
23 Run on Fridays Boolean
24 Run on Saturdays Boolean
25 Run on Sundays Boolean
26 Starting Time Time
27 Ending Time Time
28 Reference Starting Time DateTime Editable: No
30 Description Text50
31 Run in User Session Boolean Editable: No
32 User Session ID Integer
33 Job Queue Category Code Code10
34 Error Message Text250
35 Error Message 2 Text250
36 Error Message 3 Text250
37 Error Message 4 Text250
40 User Service Instance ID Integer
41 User Session Started DateTime Editable: No
42 Timeout (sec.) Integer
43 Notify On Success Boolean
44 User Language ID Integer
45 Printer Name Text250
46 Report Request Page Options Boolean
47 Rerun Delay (sec.) Integer
48 System Task ID GUID
49 Scheduled Boolean FlowField

Keys

# Fields
0 ID Clustered: Yes
1 Job Queue Category Code

Table Relations To Other Tables

Field Related Table Related Field
Object ID to Run AllObjWithCaption Object ID 1..n
Job Queue Category Code Job Queue Category Code 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field
Notification Schedule Last Scheduled Job 1..n