Job Queue Entry Buffer

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

Table Type: Company

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

Table Number: 479

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Job Queue Entry ID]
   ,[Object Type to Run]
   ,[Object ID to Run]
   ,[Description]
   ,[Job Queue Category Code]
   ,[Error Message]
   ,[Start Date_Time]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Job Queue Entry Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Job Queue Entry Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Job Queue Entry ID Primary Key Searchuniqueidentifier
3Object Type to Run Searchint
4Object ID to Run Searchint
5Description Searchnvarchar(500)
6Job Queue Category Code Searchnvarchar(20)
7Error Message Searchnvarchar(4096)
8Start Date_Time Searchdatetime
9$systemId Searchuniqueidentifier
10$systemCreatedAt Searchdatetime
11$systemCreatedBy Searchuniqueidentifier
12$systemModifiedAt Searchdatetime
13$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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