Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/472
Table Type: Company
Table Name: Job Queue Entry
Database Table Name: CRONUS UK Ltd_$Job Queue Entry$437dbf0e-84ff-417a-965d-ed2bb9650972
Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Job Queue Entry can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Job Queue Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[ID]
,[User ID]
,[XML]
,[Last Ready State]
,[Expiration Date_Time]
,[Earliest Start Date_Time]
,[Object Type to Run]
,[Object ID to Run]
,[Report Output Type]
,[Maximum No_ of Attempts to Run]
,[No_ of Attempts to Run]
,[Status]
,[Priority]
,[Record ID to Process]
,[Parameter String]
,[Recurring Job]
,[No_ of Minutes between Runs]
,[Run on Mondays]
,[Run on Tuesdays]
,[Run on Wednesdays]
,[Run on Thursdays]
,[Run on Fridays]
,[Run on Saturdays]
,[Run on Sundays]
,[Starting Time]
,[Ending Time]
,[Reference Starting Time]
,[Next Run Date Formula]
,[Description]
,[Run in User Session]
,[User Session ID]
,[Job Queue Category Code]
,[Error Message]
,[Error Message 2]
,[Error Message 3]
,[Error Message 4]
,[User Service Instance ID]
,[User Session Started]
,[Timeout (sec_)]
,[Notify On Success]
,[User Language ID]
,[Printer Name]
,[Report Request Page Options]
,[Rerun Delay (sec_)]
,[System Task ID]
,[Manual Recurrence]
,[On Hold Due to Inactivity]
,[Inactivity Timeout Period]
,[Error Message Register Id]
,[Job Timeout]
,[Recovery Task Id]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Job Queue Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in Job Queue Entry table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | ID  | uniqueidentifier |
| 3 | User ID | nvarchar(130) |
| 4 | XML | image |
| 5 | Last Ready State | datetime |
| 6 | Expiration Date_Time | datetime |
| 7 | Earliest Start Date_Time | datetime |
| 8 | Object Type to Run | int |
| 9 | Object ID to Run | int |
| 10 | Report Output Type | int |
| 11 | Maximum No_ of Attempts to Run | int |
| 12 | No_ of Attempts to Run | int |
| 13 | Status | int |
| 14 | Priority | int |
| 15 | Record ID to Process | varbinary(448) |
| 16 | Parameter String | nvarchar(500) |
| 17 | Recurring Job | tinyint |
| 18 | No_ of Minutes between Runs | int |
| 19 | Run on Mondays | tinyint |
| 20 | Run on Tuesdays | tinyint |
| 21 | Run on Wednesdays | tinyint |
| 22 | Run on Thursdays | tinyint |
| 23 | Run on Fridays | tinyint |
| 24 | Run on Saturdays | tinyint |
| 25 | Run on Sundays | tinyint |
| 26 | Starting Time | datetime |
| 27 | Ending Time | datetime |
| 28 | Reference Starting Time | datetime |
| 29 | Next Run Date Formula | varchar(32) |
| 30 | Description | nvarchar(500) |
| 31 | Run in User Session | tinyint |
| 32 | User Session ID | int |
| 33 | Job Queue Category Code | nvarchar(20) |
| 34 | Error Message | nvarchar(4096) |
| 35 | Error Message 2 | nvarchar(500) |
| 36 | Error Message 3 | nvarchar(500) |
| 37 | Error Message 4 | nvarchar(500) |
| 38 | User Service Instance ID | int |
| 39 | User Session Started | datetime |
| 40 | Timeout (sec_) | int |
| 41 | Notify On Success | tinyint |
| 42 | User Language ID | int |
| 43 | Printer Name | nvarchar(500) |
| 44 | Report Request Page Options | tinyint |
| 45 | Rerun Delay (sec_) | int |
| 46 | System Task ID | uniqueidentifier |
| 47 | Manual Recurrence | tinyint |
| 48 | On Hold Due to Inactivity | tinyint |
| 49 | Inactivity Timeout Period | int |
| 50 | Error Message Register Id | uniqueidentifier |
| 51 | Job Timeout | bigint |
| 52 | Recovery Task Id | uniqueidentifier |
| 53 | $systemId | uniqueidentifier |
| 54 | $systemCreatedAt | datetime |
| 55 | $systemCreatedBy | uniqueidentifier |
| 56 | $systemModifiedAt | datetime |
| 57 | $systemModifiedBy | uniqueidentifier |