Job Queue Log Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables JJob 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
2	ID	ID	Normal	GUID	16	ID	uniqueidentifier
3	User ID	User ID	Normal	Text	65	User ID	nvarchar(130)
4	Start Date/Time	Start Date/Time	Normal	DateTime	8	Start Date_Time	datetime
5	End Date/Time	End Date/Time	Normal	DateTime	8	End Date_Time	datetime
6	Object Type to Run	Object Type to Run	Normal	Option	4	Object Type to Run	int
	Available options are: “” “ReportCodeunit”
7	Object ID to Run	Object ID to Run	Normal	Integer	4	Object ID to Run	int
8	Object Caption to Run	Object Caption to Run	FlowField	Text	250
9	Status	Status	Normal	Option	4	Status	int
	Available options are: “Success” “In Process” “Error”
10	Description	Description	Normal	Text	250	Description	nvarchar(500)
11	Error Message	Error Message	Normal	Text	2048	Error Message	nvarchar(4096)
12	Error Message 2	Error Message 2	Normal	Text	250	Error Message 2	nvarchar(500)
13	Error Message 3	Error Message 3	Normal	Text	250	Error Message 3	nvarchar(500)
14	Error Message 4	Error Message 4	Normal	Text	250	Error Message 4	nvarchar(500)
16	Processed by User ID	Processed by User ID	Normal	Text	65	Processed by User ID	nvarchar(130)
17	Job Queue Category Code	Job Queue Category Code	Normal	Code	10	Job Queue Category Code	nvarchar(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]
18	Error Call Stack	Error Call Stack	Normal	BLOB	8	Error Call Stack	image
19	Parameter String	Parameter String	Normal	Text	250	Parameter String	nvarchar(500)
20	Error Message Register Id	Error Message Register Id	Normal	GUID	16	Error Message Register Id	uniqueidentifier
	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]
21	XML	XML	Normal	BLOB	8	XML	image
22	System Task Id	System Task Id	Normal	GUID	16
32	User Session ID	User Session ID	Normal	Integer	4	User Session ID	int
40	User Service Instance ID	User Service Instance ID	Normal	Integer	4	User Service Instance ID	int
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier