tableAL Developmentofficial - Microsoftderived - from the source, no model text

Table 474 "Job Queue Log Entry"

Base Application · System.Threading

Across versions

  1. BC23present
  2. BC241 fields changed
  3. BC25unchanged
  4. BC264 fields removed
  5. BC271 procedures added
  6. BC28-30unchanged

Neighbourhood 10 connected objects and pages

Table 471 "Job Queue Category" (relates to)Job Queue CategoryTable 701 "Error Message Register" (relates to)Error Message RegisterPage 30090 "APIV2 - Job Queue Log Entries" (pages and codeunits on it)APIV2 - Job Queue Log EntriesPage 674 "Job Queue Log Entries" (pages and codeunits on it)Job Queue Log EntriesCodeunit 456 "Job Queue Management" (event subscribers)Job Queue ManagementCodeunit 4100 "Temp Blob" (calls, 2 links)Temp BlobTable 30100 "Shpfy Cue" (referenced by)Shpfy CueGet jobQueueLogEntries (Learn pages)Get jobQueueLogEntriesjobQueueLogEntry resource type (Learn pages)jobQueueLogEntry resource typeSchedule jobs to run automatically (Learn pages)Schedule jobs to run automat…

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · System.Threading · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 30090 “APIV2 - Job Queue Log Entries” (2 Learn pages), Page 674 “Job Queue Log Entries” (1).

Properties

Property Value
Caption Job Queue Log Entry
DataClassification CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
1 Entry No. Integer — AutoIncrement
2 ID Guid Specifies the ID of the job queue entry in the log. via Page 674 “Job Queue Log Entries”
3 User ID Text[65] Specifies the ID of the user who posted the entry, to be used, for example, in the change log. via Page 674 “Job Queue Log Entries” TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
4 Start Date/Time DateTime Specifies the date and time when the job was started. via Page 674 “Job Queue Log Entries”
5 End Date/Time DateTime Specifies the date and time when the job ended. via Page 674 “Job Queue Log Entries”
6 Object Type to Run Option Specifies the type of the object that is to be run for the job. via Page 674 “Job Queue Log Entries” OptionCaption: ,,,Report,,Codeunit
7 Object ID to Run Integer Specifies the ID of the object that is to be run for the job. via Page 674 “Job Queue Log Entries”
8 Object Caption to Run Δ BC24 Text[250] Specifies the name or caption of the object that was run for the job. via Page 674 “Job Queue Log Entries” FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = field(“Object Type to Run”), “Object ID” = field(“Object ID to Run”)))
9 Status Option Specifies the status of the running of the job queue entry in a log. via Page 674 “Job Queue Log Entries” OptionCaption: Success,In Process,Error
10 Description Text[250] Specifies a description of the job queue entry in the log. via Page 674 “Job Queue Log Entries”
11 Error Message Text[2048] Specifies an error that occurred in the job queue. via Page 674 “Job Queue Log Entries”
17 Job Queue Category Code Code[10] Specifies the category code for the entry in the job queue log. via Page 674 “Job Queue Log Entries” TableRelation Table 471 “Job Queue Category” (Job Queue Category)
18 Error Call Stack BLOB — DataClassification SystemMetadata
19 Parameter String Text[250] Specifies the parameter string of the corresponding job. via Page 674 “Job Queue Log Entries”
20 Error Message Register Id Guid — TableRelation Table 701 “Error Message Register” (“Error Message Register”.ID); DataClassification SystemMetadata
21 XML Blob —
22 System Task Id Guid — DataClassification SystemMetadata
32 User Session ID Integer — DataClassification EndUserPseudonymousIdentifiers
40 User Service Instance ID Integer — DataClassification EndUserPseudonymousIdentifiers

Keys

  • Key1: Entry No. (clustered)
  • Key2: ID, Status
  • Key3: Start Date/Time, ID
  • Key4: Status
  • Key5: Object Type to Run, Object ID to Run, Status

Events published

  • OnBeforeDeleteEntries(var JobQueueLogEntry: Record "Job Queue Log Entry"; var SkipConfirm: Boolean) (integration)
  • OnBeforeMarkAsError(var JobQueueLogEntry: Record "Job Queue Log Entry"; var JobQueueEntry: Record "Job Queue Entry"; var ErrorMessage: Text) (integration)
  • OnDeleteEntriesOnBeforeDeleteAll(var JobQueueLogEntry: Record "Job Queue Log Entry") (integration)

Trigger event subscribers

Procedures

  • DeleteEntries(DaysOld: Integer)
  • ShowErrorMessage()
  • ShowErrorCallStack()
  • MarkAsError()
  • Duration(): Duration
  • SetErrorCallStack(NewCallStack: Text)
  • GetErrorCallStack(): Text

Plus 1 local procedures.

Relations

Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Job Queue Log Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources