Job Queue Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesJJob Queue Entry

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

Table Number: 472

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

   [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_)]
   ,[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 an example select of all columns including those from all joined tables

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

Show/hide columns in Job Queue Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1ID SearchIDNormalGUID16IDuniqueidentifier
2User ID Primary Key SearchUser IDNormalText65User IDnvarchar(130)
3XML SearchXMLNormalBLOB8XMLimage
4Last Ready State SearchLast Ready StateNormalDateTime8Last Ready Statedatetime
5Expiration Date/Time SearchExpiration Date/TimeNormalDateTime8Expiration Date_Timedatetime
6Earliest Start Date/Time SearchEarliest Start Date/TimeNormalDateTime8Earliest Start Date_Timedatetime
7Object Type to Run SearchObject Type to RunNormalOption4Object Type to Runint
Available options are:
  • “”
  • “ReportCodeunit”
8Object ID to Run SearchObject ID to RunNormalInteger4Object ID to Runint
9Object Caption to Run SearchObject Caption to RunFlowFieldText250
10Report Output Type SearchReport Output TypeNormalOption4Report Output Typeint
Available options are:
  • “PDF”
  • “Word”
  • “Excel”
  • “Print”
  • “None (Processing only)”
11Maximum No. of Attempts to Run SearchMaximum No. of Attempts to RunNormalInteger4Maximum No_ of Attempts to Runint
12No. of Attempts to Run SearchNo. of Attempts to RunNormalInteger4No_ of Attempts to Runint
13Status SearchStatusNormalOption4Statusint
Available options are:
  • “Ready”
  • “In Process”
  • “Error”
  • “On Hold”
  • “Finished”
  • “On Hold with Inactivity Timeout”
14Priority SearchPriorityNormalInteger4Priorityint
15Record ID to Process SearchRecord ID to ProcessNormalRecordID448Record ID to Processvarbinary(448)
16Parameter String SearchParameter StringNormalText250Parameter Stringnvarchar(500)
17Recurring Job SearchRecurring JobNormalBoolean4Recurring Jobtinyint
18No. of Minutes between Runs SearchNo. of Minutes between RunsNormalInteger4No_ of Minutes between Runsint
19Run on Mondays SearchRun on MondaysNormalBoolean4Run on Mondaystinyint
20Run on Tuesdays SearchRun on TuesdaysNormalBoolean4Run on Tuesdaystinyint
21Run on Wednesdays SearchRun on WednesdaysNormalBoolean4Run on Wednesdaystinyint
22Run on Thursdays SearchRun on ThursdaysNormalBoolean4Run on Thursdaystinyint
23Run on Fridays SearchRun on FridaysNormalBoolean4Run on Fridaystinyint
24Run on Saturdays SearchRun on SaturdaysNormalBoolean4Run on Saturdaystinyint
25Run on Sundays SearchRun on SundaysNormalBoolean4Run on Sundaystinyint
26Starting Time SearchStarting TimeNormalTime4Starting Timedatetime
27Ending Time SearchEnding TimeNormalTime4Ending Timedatetime
28Reference Starting Time SearchReference Starting TimeNormalDateTime8Reference Starting Timedatetime
29Next Run Date Formula SearchNext Run Date FormulaNormalDateFormula32Next Run Date Formulavarchar(32)
30Description SearchDescriptionNormalText250Descriptionnvarchar(500)
31Run in User Session SearchRun in User SessionNormalBoolean4Run in User Sessiontinyint
32User Session ID SearchUser Session IDNormalInteger4User Session IDint
33Job 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 Entry].[Job Queue Category Code]
	       ,[Job Queue Category].[Code]
	FROM
	       [CRONUS UK Ltd_$Job Queue Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Job Queue Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Category]
	              ON
	                     [Job Queue Entry].[Job Queue Category Code] = [Job Queue Category].[Code]
34Error Message SearchError MessageNormalText2048Error Messagenvarchar(4096)
35Error Message 2 SearchError Message 2NormalText250Error Message 2nvarchar(500)
36Error Message 3 SearchError Message 3NormalText250Error Message 3nvarchar(500)
37Error Message 4 SearchError Message 4NormalText250Error Message 4nvarchar(500)
40User Service Instance ID SearchUser Service Instance IDNormalInteger4User Service Instance IDint
41User Session Started SearchUser Session StartedNormalDateTime8User Session Starteddatetime
42Timeout (sec.) SearchTimeout (sec.)NormalInteger4Timeout (sec_)int
43Notify On Success SearchNotify On SuccessNormalBoolean4Notify On Successtinyint
44User Language ID SearchUser Language IDNormalInteger4User Language IDint
45Printer Name SearchPrinter NameNormalText250Printer Namenvarchar(500)
46Report Request Page Options SearchReport Request Page OptionsNormalBoolean4Report Request Page Optionstinyint
47Rerun Delay (sec.) SearchRerun Delay (sec.)NormalInteger4Rerun Delay (sec_)int
48System Task ID SearchSystem Task IDNormalGUID16
49Scheduled SearchScheduledFlowFieldBoolean4
50Manual Recurrence SearchManual RecurrenceNormalBoolean4Manual Recurrencetinyint
51On Hold Due to Inactivity SearchOn Hold Due to InactivityNormalBoolean4On Hold Due to Inactivitytinyint
52Inactivity Timeout Period SearchInactivity Timeout PeriodNormalInteger4Inactivity Timeout Periodint
53Error 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 Entry].[Error Message Register Id]
	       ,[Error Message Register].[ID]
	FROM
	       [CRONUS UK Ltd_$Job Queue Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Error Message Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Error Message Register]
	              ON
	                     [Job Queue Entry].[Error Message Register Id] = [Error Message Register].[ID]
54Job Timeout SearchJob TimeoutNormalDuration8Job Timeoutbigint
55Recovery Task Id SearchRecovery Task IdNormalGUID16Recovery Task Iduniqueidentifier
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 Entry].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Job Queue Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Entry]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Job Queue Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesJJob Queue Entry

Leave a Reply

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