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: 474

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
   [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]
   ,[User Session ID]
   ,[User Service Instance ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Job Queue Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Job Queue Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Log Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Job Queue Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Category]
      ON
         [Job Queue Log Entry].[Job Queue Category Code] = [Job Queue Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Error Message Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Error Message Register]
      ON
         [Job Queue Log Entry].[Error Message Register Id] = [Error Message Register].[ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Job Queue Log Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Job Queue Log Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Job Queue Log Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2ID SearchIDNormalGUID16IDuniqueidentifier
3User ID SearchUser IDNormalText65User IDnvarchar(130)
4Start Date/Time SearchStart Date/TimeNormalDateTime8Start Date_Timedatetime
5End Date/Time SearchEnd Date/TimeNormalDateTime8End Date_Timedatetime
6Object Type to Run SearchObject Type to RunNormalOption4Object Type to Runint
Available options are:
  • “”
  • “ReportCodeunit”
7Object ID to Run SearchObject ID to RunNormalInteger4Object ID to Runint
8Object Caption to Run SearchObject Caption to RunFlowFieldText250
9Status SearchStatusNormalOption4Statusint
Available options are:
  • “Success”
  • “In Process”
  • “Error”
10Description SearchDescriptionNormalText250Descriptionnvarchar(500)
11Error Message SearchError MessageNormalText2048Error Messagenvarchar(4096)
12Error Message 2 SearchError Message 2NormalText250Error Message 2nvarchar(500)
13Error Message 3 SearchError Message 3NormalText250Error Message 3nvarchar(500)
14Error Message 4 SearchError Message 4NormalText250Error Message 4nvarchar(500)
16Processed by User ID SearchProcessed by User IDNormalText65Processed by User IDnvarchar(130)
17Job Queue Category Code SearchJob Queue Category CodeNormalCode10Job Queue Category Codenvarchar(20)
Key to join to the Job Queue Category table.

Show/hide example query

SELECT
       [Job Queue Log Entry].[Job Queue Category Code]
       ,[Job Queue Category].[Code]
FROM
       [CRONUS UK Ltd_$Job Queue Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Log Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job Queue Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Category]
              ON
                     [Job Queue Log Entry].[Job Queue Category Code] = [Job Queue Category].[Code]
18Error Call Stack SearchError Call StackNormalBLOB8Error Call Stackimage
19Parameter String SearchParameter StringNormalText250Parameter Stringnvarchar(500)
20Error Message Register Id SearchError Message Register IdNormalGUID16Error Message Register Iduniqueidentifier
Key to join to the Error Message Register table.

Show/hide example query

SELECT
       [Job Queue Log Entry].[Error Message Register Id]
       ,[Error Message Register].[ID]
FROM
       [CRONUS UK Ltd_$Job Queue Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Log Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Error Message Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Error Message Register]
              ON
                     [Job Queue Log Entry].[Error Message Register Id] = [Error Message Register].[ID]
21XML SearchXMLNormalBLOB8XMLimage
22System Task Id SearchSystem Task IdNormalGUID16
32User Session ID SearchUser Session IDNormalInteger4User Session IDint
40User Service Instance ID SearchUser Service Instance IDNormalInteger4User Service Instance IDint
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Job Queue Log Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Job Queue Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Log Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Job Queue Log Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Job Queue Log Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Job Queue Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Log Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Job Queue Log Entry].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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