Job 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: 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 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
   [timestamp]
   ,[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_)]
   ,[System Task ID]
   ,[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 columns in Job Queue Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3User ID Searchnvarchar(130)
4XML Searchimage
5Last Ready State Searchdatetime
6Expiration Date_Time Searchdatetime
7Earliest Start Date_Time Searchdatetime
8Object Type to Run Searchint
9Object ID to Run Searchint
10Report Output Type Searchint
11Maximum No_ of Attempts to Run Searchint
12No_ of Attempts to Run Searchint
13Status Searchint
14Priority Searchint
15Record ID to Process Searchvarbinary(448)
16Parameter String Searchnvarchar(500)
17Recurring Job Searchtinyint
18No_ of Minutes between Runs Searchint
19Run on Mondays Searchtinyint
20Run on Tuesdays Searchtinyint
21Run on Wednesdays Searchtinyint
22Run on Thursdays Searchtinyint
23Run on Fridays Searchtinyint
24Run on Saturdays Searchtinyint
25Run on Sundays Searchtinyint
26Starting Time Searchdatetime
27Ending Time Searchdatetime
28Reference Starting Time Searchdatetime
29Next Run Date Formula Searchvarchar(32)
30Description Searchnvarchar(500)
31Run in User Session Searchtinyint
32User Session ID Searchint
33Job Queue Category Code Searchnvarchar(20)
34Error Message Searchnvarchar(4096)
35Error Message 2 Searchnvarchar(500)
36Error Message 3 Searchnvarchar(500)
37Error Message 4 Searchnvarchar(500)
38User Service Instance ID Searchint
39User Session Started Searchdatetime
40Timeout (sec_) Searchint
41Notify On Success Searchtinyint
42User Language ID Searchint
43Printer Name Searchnvarchar(500)
44Report Request Page Options Searchtinyint
45Rerun Delay (sec_) Searchint
46System Task ID Searchuniqueidentifier
47Manual Recurrence Searchtinyint
48On Hold Due to Inactivity Searchtinyint
49Inactivity Timeout Period Searchint
50Error Message Register Id Searchuniqueidentifier
51Job Timeout Searchbigint
52Recovery Task Id Searchuniqueidentifier
53$systemId Searchuniqueidentifier
54$systemCreatedAt Searchdatetime
55$systemCreatedBy Searchuniqueidentifier
56$systemModifiedAt Searchdatetime
57$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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