Job Queue Log Entry

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/474

Table Type: Company

Table Name: Job Queue Log Entry
Database Table Name: CRONUS UK Ltd_$Job Queue Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 Log Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Job Queue Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[ID]
   ,[User ID]
   ,[Start Date_Time]
   ,[End Date_Time]
   ,[Object Type to Run]
   ,[Object ID to Run]
   ,[Status]
   ,[Description]
   ,[Error Message]
   ,[Error Message 2]
   ,[Error Message 3]
   ,[Error Message 4]
   ,[Processed by User ID]
   ,[Job Queue Category Code]
   ,[Error Call Stack]
   ,[Parameter String]
   ,[Error Message Register Id]
   ,[XML]
   ,[System Task Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Job Queue Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Job Queue Log Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3ID Searchuniqueidentifier
4User ID Searchnvarchar(130)
5Start Date_Time Searchdatetime
6End Date_Time Searchdatetime
7Object Type to Run Searchint
8Object ID to Run Searchint
9Status Searchint
10Description Searchnvarchar(500)
11Error Message Searchnvarchar(4096)
12Error Message 2 Searchnvarchar(500)
13Error Message 3 Searchnvarchar(500)
14Error Message 4 Searchnvarchar(500)
15Processed by User ID Searchnvarchar(130)
16Job Queue Category Code Searchnvarchar(20)
17Error Call Stack Searchimage
18Parameter String Searchnvarchar(500)
19Error Message Register Id Searchuniqueidentifier
20XML Searchimage
21System Task Id Searchuniqueidentifier
22$systemId Searchuniqueidentifier
23$systemCreatedAt Searchdatetime
24$systemCreatedBy Searchuniqueidentifier
25$systemModifiedAt Searchdatetime
26$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *