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

Table 472 "Job Queue Entry"

Base Application · System.Threading

Across versions

  1. BC23present
  2. BC2411 procedures added, 3 fields changed
  3. BC25declaration changed
  4. BC267 fields removed, 1 procedures added
  5. BC271 procedures changed, 1 procedures removed
  6. BC282 events removed, 1 procedures removed
  7. BC291 events added
  8. BC30unchanged

Neighbourhood 114 connected objects and pages

Table 471 "Job Queue Category" (relates to)Job Queue CategoryTable 701 "Error Message Register" (relates to)Page 672 "Job Queue Entries" (pages and codeunits on it, 3 links)Job Queue EntriesCodeunit 104 "Update Name In Ledger Entries" (pages and codeunits on it)Update Name In Ledger EntriesCodeunit 107 "Import and Consolidate" (pages and codeunits on it)Import and ConsolidateCodeunit 1328 "Top Customers By Sales Job" (pages and codeunits on it)Top Customers By Sales JobCodeunit 137 "OCR Inc. Doc. via Job Queue" (pages and codeunits on it)Codeunit 1415 "Automatic Import of Bank Stmt." (pages and codeunits on it)Automatic Import of Bank Stmt.Codeunit 1441 "RC Headlines Executor" (pages and codeunits on it)Codeunit 1509 "Notification Entry Dispatcher" (pages and codeunits on it)Notification Entry DispatcherCodeunit 1512 "Workflow Create Payment Line" (pages and codeunits on it)Workflow Create Payment LineCodeunit 1683 "Email Logging Job Runner" (pages and codeunits on it)Codeunit 1798 "Data Migration Mgt." (pages and codeunits on it)Codeunit 1951 "LP Model Management" (pages and codeunits on it)Codeunit 20038 "APIV1 - Send Sales Document" (pages and codeunits on it)Codeunit 2103 "O365 Sales Cancel Invoice" (pages and codeunits on it)Codeunit 250 "Gen. Jnl.-Post via Job Queue" (pages and codeunits on it)Codeunit 2581 "Dim Correction Run" (pages and codeunits on it)Codeunit 2582 "Dimension Correction Undo" (pages and codeunits on it)Codeunit 2583 "Dim Correction Validate" (pages and codeunits on it)Codeunit 2584 "Dim Corr Analysis View" (pages and codeunits on it)Codeunit 260 "Document-Mailing" (pages and codeunits on it)Codeunit 30038 "APIV2 - Send Sales Document" (pages and codeunits on it)Table extension 472 "Job Queue Entry Ext." (extended by)Codeunit 1550 "Record Restriction Mgt." (event subscribers, 2 links)Record Restriction Mgt.Codeunit 456 "Job Queue Management" (event subscribers, 2 links)Job Queue ManagementCodeunit 5341 "CRM Int. Table. Subscriber" (event subscribers, 2 links)CRM Int. Table. SubscriberCodeunit 1328 "Top Customers By Sales Job" (event subscribers)Codeunit 1535 "Approvals Mgmt." (event subscribers)Codeunit 1681 "Email Logging Management" (event subscribers)Codeunit 2580 "Dimension Correction Mgt" (event subscribers)Codeunit 30005 "APIV2 - Job Queue Management" (event subscribers)Codeunit 30101 "Shpfy Background Syncs" (event subscribers)Codeunit 448 "Job Queue Dispatcher" (calls, 4 links)Job Queue DispatcherCodeunit 43 "Language" (calls, 2 links)LanguageCodeunit 9803 "Job Queue Telemetry" (calls, 2 links)Job Queue TelemetryTable 1513 "Notification Schedule" (referenced by)Table 5370 "CRM Synch. Job Status Cue" (referenced by)Get jobQueueEntries (Learn pages)jobQueueEntry resource type (Learn pages)

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 672 “Job Queue Entries” (4 Learn pages), Page 30091 “APIV2 - Job Queue Entries” (2), Page 673 “Job Queue Entry Card” (1), Page 676 “Schedule a Job” (1), Page 682 “Schedule a Report” (1), Page 2593 “Dim Correction Schedule” (1).

Properties

Property Value
Caption Job Queue Entry
DataClassification CustomerContent
Permissions TableData “Job Queue Entry” = rimd, TableData “Job Queue Log Entry” = rimd, TableData “Job Queue Category” = rm

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 ID Guid —
2 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 673 “Job Queue Entry Card” TableRelation User.“User Name”; not editable; DataClassification EndUserIdentifiableInformation
3 XML BLOB —
4 Last Ready State DateTime Specifies the date and time when the job queue entry was last set to Ready and sent to the job queue. via Page 673 “Job Queue Entry Card” not editable
5 Expiration Date/Time DateTime Specifies the date and time when the job queue entry is to expire, after which the job queue entry will not be run. The format for the date and time must be month/day/year hour:minute, and then AM or PM. For example, 3/10/2021 12:00 AM. via Page 673 “Job Queue Entry Card”
6 Earliest Start Date/Time DateTime Specifies the earliest date and time when the job queue entry should be run. The format for the date and time must be month/day/year hour:minute, and then AM or PM. For example, 3/10/2021 12:00 AM. via Page 673 “Job Queue Entry Card”
7 Object Type to Run Option Specifies the type of the object, report or codeunit, that is to be run for the job queue entry. After you specify a type, you then select an object ID of that type in the Object ID to Run field. via Page 673 “Job Queue Entry Card” OptionCaption: ,,,Report,,Codeunit
8 Object ID to Run Integer Specifies the ID of the object that is to be run for this job. You can select an ID that is of the object type that you have specified in the Object Type to Run field. via Page 673 “Job Queue Entry Card” TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = field(“Object Type to Run”))
9 Object Caption to Run Δ BC24 Text[250] Specifies the name of the object that is selected in the Object ID to Run field. via Page 673 “Job Queue Entry Card” FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = field(“Object Type to Run”), “Object ID” = field(“Object ID to Run”))); not editable
10 Report Output Type Enum “Job Queue Report Output Type” Specifies the output of the scheduled report. via Page 673 “Job Queue Entry Card” enum Enum 482 “Job Queue Report Output Type”
11 Maximum No. of Attempts to Run Δ BC24 Integer Specifies how many times a job queue task should be rerun after a job queue fails to run. This is useful for situations in which a task might be unresponsive. For example, a task might be unresponsive because it depends on an external resource that is not always available. via Page 673 “Job Queue Entry Card”
12 No. of Attempts to Run Integer — not editable
13 Status Δ BC24 Option Specifies the status of the job queue entry. When you create a job queue entry, its status is set to On Hold. You can set the status to Ready and back to On Hold. Otherwise, status information in this field is updated automatically. via Page 673 “Job Queue Entry Card” OptionCaption: Ready,In Process,Error,On Hold,Finished,On Hold with Inactivity Timeout,Waiting; not editable
15 Record ID to Process RecordID —
16 Parameter String Text[250] Specifies a text string that is used as a parameter by the job queue when it is run. via Page 673 “Job Queue Entry Card”
17 Recurring Job Boolean Specifies if the job queue entry is recurring. If the Recurring Job check box is selected, then the job queue entry is recurring. If the check box is cleared, the job queue entry is not recurring. After you specify that a job queue entry is a recurring one, you must specify on which days of the week… via Page 673 “Job Queue Entry Card”
18 No. of Minutes between Runs Integer Specifies the minimum number of minutes that are to elapse between runs of a job queue entry. The value cannot be less than one minute. This field only has meaning if the job queue entry is set to be a recurring job. If you use a no. of minutes between runs, the date formula setting is cleared. via Page 673 “Job Queue Entry Card”
19 Run on Mondays Boolean Specifies that the job queue entry runs on Mondays. via Page 673 “Job Queue Entry Card”
20 Run on Tuesdays Boolean Specifies that the job queue entry runs on Tuesdays. via Page 673 “Job Queue Entry Card”
21 Run on Wednesdays Boolean Specifies that the job queue entry runs on Wednesdays. via Page 673 “Job Queue Entry Card”
22 Run on Thursdays Boolean Specifies that the job queue entry runs on Thursdays. via Page 673 “Job Queue Entry Card”
23 Run on Fridays Boolean Specifies that the job queue entry runs on Fridays. via Page 673 “Job Queue Entry Card”
24 Run on Saturdays Boolean Specifies that the job queue entry runs on Saturdays. via Page 673 “Job Queue Entry Card”
25 Run on Sundays Boolean Specifies that the job queue entry runs on Sundays. via Page 673 “Job Queue Entry Card”
26 Starting Time Time Specifies the earliest time of the day that the recurring job queue entry is to be run. via Page 673 “Job Queue Entry Card”
27 Ending Time Time Specifies the latest time of the day that the recurring job queue entry is to be run. via Page 673 “Job Queue Entry Card”
28 Reference Starting Time DateTime — not editable
29 Next Run Date Formula DateFormula Specifies the date formula that is used to calculate the next time the recurring job queue entry will run. If you use a date formula, all other recurrence settings are cleared. via Page 673 “Job Queue Entry Card” DataClassification SystemMetadata
30 Description Text[250] Specifies a description of the job queue entry. You can edit and update the description on the job queue entry card. The description is also displayed in the Job Queue Entries window, but it cannot be updated there. via Page 673 “Job Queue Entry Card”
31 Run in User Session Boolean — not editable
32 User Session ID Integer — DataClassification EndUserPseudonymousIdentifiers
33 Job Queue Category Code Code[10] Specifies the code of the job queue category to which the job queue entry belongs. Choose the field to select a code from the list. via Page 673 “Job Queue Entry Card” TableRelation Table 471 “Job Queue Category” (Job Queue Category)
34 Error Message Text[2048] Specifies the latest error message that was received from the job queue entry. You can view the error message if the Status field is set to Error. The field can contain up to 250 characters. via Page 5373 “CRM Synch. Job Queue”
40 User Service Instance ID Integer — DataClassification EndUserPseudonymousIdentifiers
41 User Session Started DateTime Specifies the date and time that a user session started. via Page 672 “Job Queue Entries” not editable
43 Notify On Success Boolean —
44 User Language ID Integer —
45 Printer Name Text[250] Specifies the printer to use to print the scheduled report. via Page 673 “Job Queue Entry Card”
46 Report Request Page Options Boolean Specifies whether options on the report request page have been set for scheduled report job. If the check box is selected, then options have been set for the scheduled report. via Page 673 “Job Queue Entry Card”
47 Rerun Delay (sec.) Integer Specifies how many seconds to wait before re-running this job queue task in the event of a failure. via Page 673 “Job Queue Entry Card”
48 System Task ID Guid —
49 Scheduled Boolean Specifies if the job queue entry has been scheduled to run automatically, which happens when an entry changes status to Ready. If the field is cleared, the job queue entry is not scheduled to run. via Page 672 “Job Queue Entries” FlowField: exist(“Scheduled Task” where(ID = field(“System Task ID”)))
50 Manual Recurrence Boolean —
52 Inactivity Timeout Period Integer Specifies the number of minutes that pass before a recurring job that has the status On Hold With Inactivity Timeout is automatically restated. The value cannot be less than five minutes. via Page 673 “Job Queue Entry Card”
53 Error Message Register Id Guid — TableRelation Table 701 “Error Message Register” (“Error Message Register”.ID); DataClassification SystemMetadata
54 Job Timeout Duration Specifies the maximum time that the job queue entry is allowed to run. via Page 673 “Job Queue Entry Card” DataClassification SystemMetadata
56 Entry No. + BC24 BigInteger — AutoIncrement; DataClassification SystemMetadata
57 Priority Within Category + BC24 Enum “Job Queue Priority” Specifies the priority of the job within the category. Is only used when the job has a Category Code enum Enum 470 “Job Queue Priority”; DataClassification SystemMetadata

Keys

  • Key1: ID (clustered)
  • Key2: Job Queue Category Code, Priority Within Category, Entry No.
  • Key3: Last Ready State
  • Key4: Recurring Job
  • Key5: System Task ID
  • Key6: User ID, Status, Recurring Job
  • Key7: Object ID to Run, Object Type to Run
  • Key8: Error Message Register Id

Events published

  • OnAfterReschedule(var JobQueueEntry: Record "Job Queue Entry") (integration)
  • OnAfterCleanupAfterExecution(var JobQueueEntry: Record "Job Queue Entry") (integration)
  • OnAfterGetXmlContent(var JobQueueEntry: Record "Job Queue Entry"; var Params: Text) (integration)
  • OnAfterRunReportRequestPage(JobQueueEntry: Record "Job Queue Entry"; var Params: Text) (integration)
  • OnAfterSetDefaultValues(var JobQueueEntry: Record "Job Queue Entry") (integration)
  • OnBeforeClearServiceValues(var JobQueueEntry: Record "Job Queue Entry") (integration)
  • OnAfterFinalizeRun(JobQueueEntry: Record "Job Queue Entry") (integration)
  • OnBeforeInsertLogEntry(var JobQueueLogEntry: Record "Job Queue Log Entry"; var JobQueueEntry: Record "Job Queue Entry") (integration)
  • OnBeforeModifyLogEntry(var JobQueueLogEntry: Record "Job Queue Log Entry"; var JobQueueEntry: Record "Job Queue Entry") (integration)
  • OnBeforeScheduleTask(var JobQueueEntry: Record "Job Queue Entry"; var TaskGUID: Guid; var IsHandled: Boolean) (integration)
  • OnBeforeSetRecurringField(var JobQueueEntry: Record "Job Queue Entry"; var IsHandled: Boolean) (integration)
  • OnBeforeSetStatusValue(var JobQueueEntry: Record "Job Queue Entry"; var xJobQueueEntry: Record "Job Queue Entry"; var NewStatus: Option; var IsHandled: Boolean) (integration)
  • OnBeforeTryRunJobQueueSendNotification(var JobQueueEntry: Record "Job Queue Entry"; var IsHandled: Boolean) (integration)
  • OnFindingIfJobNeedsToBeRun(var Result: Boolean) Δ BC24 (integration)
  • OnInsertOnBeforeSetDefaultValues(var JobQueueEntry: Record "Job Queue Entry"; var SetupUserId: Boolean) (integration)
  • OnReuseExisingJobFromId(var JobQueueEntry: Record "Job Queue Entry"; ExecutionDateTime: DateTime) + BC28 − BC28 (internal)
  • OnRunReportRequestPageBeforeGetReportParameters(JobQueueEntry: Record "Job Queue Entry") (integration)
  • OnSetXmlContentOnBeforeModify(var JobQueueEntry: Record "Job Queue Entry"; var Params: Text) (integration)
  • OnBeforeCleanupAfterExecution(var JobQueueEntry: Record "Job Queue Entry"; var IsHandled: Boolean) (integration)
  • OnBeforeRestart(JobQueueEntry: Record "Job Queue Entry") (integration)
  • OnAfterSetReportParameters(var JobQueueEntry: Record "Job Queue Entry") (integration)
  • OnScheduleRecurrentJobQueueEntryOnBeforeEnqueueTask(var JobQueueEntry: Record "Job Queue Entry") (integration)
  • OnModifyOnAfterRunParametersChangedCalculated(var JobQueueEntry: Record "Job Queue Entry"; var xJobQueueEntry: Record "Job Queue Entry"; var RunParametersChanged: Boolean) (integration)
  • OnBeforeHandleExecutionError(var JobQueueEntry: Record "Job Queue Entry"; var IsHandled: Boolean) (integration)
  • OnBeforeIsReadyToStart(var JobQueueEntry: Record "Job Queue Entry"; var ReadyToStart: Boolean; var IsHandled: Boolean) (integration)
  • OnAfterSetStatusValue(var JobQueueEntry: Record "Job Queue Entry"; var xJobQueueEntry: Record "Job Queue Entry") + BC26 (integration)
  • OnAfterShowStatusMsg(JobQueueEntry: Record "Job Queue Entry"; JQID: Guid) + BC29 (integration)

Trigger event subscribers

Procedures

  • DoesExistLocked(): Boolean
  • RefreshLocked()
  • GetRecLockedExtendedTimeout(): Boolean + BC24: Allow up to 10 minutes of lock, in order to reduce lock timeouts
  • IsExpired(AtDateTime: DateTime): Boolean
  • IsReadyToStart(): Boolean
  • ShowErrorMessage()
  • SetError(ErrorText: Text)
  • SetResult(PrevStatus: Option) (internal)
  • SetResult(IsSuccess: Boolean; PrevStatus: Option; ErrorMessageRegisterId: Guid)
  • SetResultDeletedEntry()
  • FinalizeRun()
  • GetLastLogEntryNo(): Integer
  • InsertLogEntry(var JobQueueLogEntry: Record "Job Queue Log Entry")
  • FinalizeLogEntry(JobQueueLogEntry: Record "Job Queue Log Entry")
  • FinalizeLogEntry(JobQueueLogEntry: Record "Job Queue Log Entry"; LastErrorCallStack: Text)
  • SetStatus(NewStatus: Option)
  • Cancel()
  • DeleteTask()
  • DeleteTasks()
  • Restart()
  • CheckRequiredPermissions()
  • HasRequiredPermissions(): Boolean
  • TryCheckRequiredPermissions() (internal)
  • CancelTask() + BC24
  • CancelTask(EmitTelemetry: Boolean) + BC24 (internal)
  • ScheduleTask(): Guid
  • DefaultJobTimeout(): Duration
  • ReuseExistingJobFromID(JobID: Guid; ExecutionDateTime: DateTime): Boolean
  • ReuseExistingJobFromCategory(JobQueueCategoryCode: Code[10]; ExecutionDateTime: DateTime): Boolean
  • ReuseExistingJobFromCategoryAndUser(JobQueueCategoryCode: Code[10]; UserId: Text; ExecutionDateTime: DateTime): Boolean
  • ReuseExistingJobFromCategoryAndParamString(JobQueueCategoryCode: Code[10]; ParamString: Text[250]; ExecutionDateTime: DateTime): Boolean (internal)
  • ReuseExistingJobFromUserCategoryAndParamString(UserId: Text; JobQueueCategoryCode: Code[10]; ParamString: Text[250]; ExecutionDateTime: DateTime): Boolean (internal)
  • ReuseExistingJobFromUserCategoryCodeunitAndParamString(UserId: Text; JobQueueCategoryCode: Code[10]; Codeunit: Integer; ParamString: Text[250]; ExecutionDateTime: DateTime): Boolean + BC26 (internal)
  • CleanupAfterExecution()
  • IsNextRunDateFormulaSet(): Boolean Δ BC24
  • ShowStatusMsg(JQID: Guid)
  • LookupRecordToProcess()
  • LookupObjectID(var NewObjectID: Integer): Boolean
  • GetXmlContent(): Text
  • SetXmlContent(Params: Text)
  • GetReportParameters(): Text
  • SetReportParameters(Params: Text)
  • RunReportRequestPage() Δ BC27
  • ScheduleJobQueueEntry(CodeunitID: Integer; RecordIDToProcess: RecordID)
  • ScheduleJobQueueEntryWithParameters(CodeunitID: Integer; RecordIDToProcess: RecordID; JobParameter: Text[250])
  • ScheduleJobQueueEntryForLater(CodeunitID: Integer; StartDateTime: DateTime; JobQueueCategoryCode: Code[10]; JobParameter: Text)
  • GetStartingDateTime(Date: DateTime): DateTime
  • GetEndingDateTime(Date: DateTime): DateTime
  • ScheduleRecurrentJobQueueEntry(ObjType: Option; ObjID: Integer; RecId: RecordID)
  • ScheduleRecurrentJobQueueEntryWithFrequency(ObjType: Option; ObjID: Integer; RecId: RecordID; NoofMinutesbetweenRuns: Integer)
  • ScheduleRecurrentJobQueueEntryWithFrequency(ObjType: Option; ObjID: Integer; RecId: RecordID; NoofMinutesbetweenRuns: Integer; StartTime: Time)
  • ScheduleRecurrentJobQueueEntryWithFrequency(ObjType: Option; ObjID: Integer; RecId: RecordID; NoofMinutesbetweenRuns: Integer; MaxAttemptsToRun: Integer; RerunDelay: Integer; StartingTime: Time) (internal)
  • ScheduleRecurrentJobQueueEntryWithRunDateFormula(ObjType: Option; ObjID: Integer; RecId: RecordID; JobQueueCategoryCode: Code[10]; MaxAttemptsToRun: Integer; NextRunDateFormula: DateFormula; StartingTime: Time)
  • ScheduleRecurrentJobQueueEntryWithRunDateFormula(ObjType: Option; ObjID: Integer; RecId: RecordID; JobQueueCategoryCode: Code[10]; MaxAttemptsToRun: Integer; NextRunDateFormula: DateFormula; StartingTime: Time; JobTimeout: Duration) (internal)
  • InitRecurringJob(NoofMinutesbetweenRuns: Integer)
  • FindJobQueueEntry(ObjType: Option; ObjID: Integer): Boolean
  • GetDefaultDescription(): Text[250]
  • FilterInactiveOnHoldEntries()
  • DoesJobNeedToBeRun(): Boolean
  • RemoveFailedJobs(OnlyForCurrentUser: Boolean) + BC24 (internal)
  • AnyReadyJobInCategory(var JobQueueCategory: Record "Job Queue Category"): Boolean + BC24 (internal)
  • ActivateNextJobInCategory(var JobQueueCategory: Record "Job Queue Category"): Boolean + BC24 + BC24 (internal)
  • RefreshRecoveryTask(var JobQueueCategory: Record "Job Queue Category") + BC24 (internal)
  • ActivateNextJobInCategoryIfAny() + BC24 (internal)
  • ActivateNextJobInCategory() + BC24 + BC24 (internal)
  • SetPriority(NewPriority: Enum "Job Queue Priority") + BC24 (internal)

Plus 14 local procedures.

Triggers

OnDelete, OnInsert, OnModify

Relations

Referenced by

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

Pages and codeunits on this table

Extended by

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.

Recent changes

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 Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources