Table 474 "Job Queue Log Entry"
Base Application · System.Threading
Across versions
- BC23present
- BC241 fields changed
- BC25unchanged
- BC264 fields removed
- BC271 procedures added
- BC28-30unchanged
Neighbourhood 10 connected objects and pages
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
- OnBeforeDeleteEvent: Codeunit 456 “Job Queue Management” OnBeforeDeleteJobQueueLogEntry
Procedures
DeleteEntries(DaysOld: Integer)ShowErrorMessage()ShowErrorCallStack()MarkAsError()Duration(): DurationSetErrorCallStack(NewCallStack: Text)GetErrorCallStack(): Text
Plus 1 local procedures.
Relations
- Job Queue Category Code: TableRelation Table 471 “Job Queue Category”
- Error Message Register Id: TableRelation Table 701 “Error Message Register”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 30100 “Shpfy Cue”: Synchronization Errors
Pages and codeunits on this table
- Page 30090 “APIV2 - Job Queue Log Entries” (source table)
- Page 674 “Job Queue Log Entries” (source 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.
- Codeunit 4100 “Temp Blob” (2 calls:
GetErrorCallStack → CreateInStream,GetErrorCallStack → FromRecord)
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.