Codeunit 456 Job Queue Management
src/Layers/W1/BaseApp/Modules/System/JobQueue/JobQueueManagement.Codeunit.al570 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Threading;using System.Environment;using System.Security.User;using System.Utilities;codeunit 456 "Job Queue Management"{ var JobQueueTelemetry: Codeunit "Job Queue Telemetry"; RunOnceQst: label 'This will create a temporary non-recurrent copy of this job and will run it once in the foreground.\Do you want to continue?'; ExecuteBeginMsg: label 'Executing job queue entry...'; ExecuteEndSuccessMsg: label 'Job finished executing.\Status: %1', Comment = '%1 is a status value, e.g. Success'; ExecuteEndErrorMsg: label 'Job finished executing.\Status: %1\Error: %2', Comment = '%1 is a status value, e.g. Success, %2=Error message'; JobSomethingWentWrongMsg: Label 'Something went wrong and the job has stopped. Likely causes are system updates or routine maintenance processes. To restart the job, set the status to Ready.'; JobSomethingWentWrongMsgErr: Label 'Something went wrong and the job has stopped. Likely causes are system updates or routine maintenance processes. The job will automatically run again.'; JobQueueStatusChangeTxt: Label 'The status for Job Queue Entry: %1 has changed.', Comment = '%1 is the Job Queue Entry Id', Locked = true; TelemetryStaleJobQueueEntryTxt: Label 'Updated Job Queue Entry status to error as it is stale. Please investigate associated Task Id for error.', Locked = true; TelemetryStaleJobQueueLogEntryTxt: Label 'Updated Job Queue Log Entry status to error as it is stale. Please investigate associated Task Id for error.', Locked = true; TelemetryStaleRetriableJobQueueLogEntryTxt: Label 'Updated Job Queue Log Entry status to error as it is was retriable by platform.', Locked = true; RunJobQueueOnceTxt: Label 'Running job queue once.', Locked = true; TooManyScheduledTasksLinkTxt: Label 'Learn more'; TooManyScheduledTasksNotificationMsg: Label 'There are more than 100,000 scheduled tasks in the system. This can prevent Job Queues and tasks from running in a timely manner. Please contact your system administrator.'; TooManyScheduledTasksNotificationGuidLbl: Label 'cedc5167-e04c-4127-b7dd-114d1749700a', Locked = true; trigger OnRun() begin end; internal procedure CheckUserInJobQueueAdminList(UserName: Text): Boolean var JobQueueAdminList: Record "Job Queue Notified Admin"; begin exit(JobQueueAdminList.Get(UserName)); end; procedure CreateJobQueueEntry(var JobQueueEntry: Record "Job Queue Entry") var EarliestStartDateTime: DateTime; ReportOutputType: Enum "Job Queue Report Output Type"; ObjectTypeToRun: Option; ObjectIdToRun: Integer; NoOfMinutesBetweenRuns: Integer; RecurringJob: Boolean; begin NoOfMinutesBetweenRuns := JobQueueEntry."No. of Minutes between Runs"; EarliestStartDateTime := JobQueueEntry."Earliest Start Date/Time"; ReportOutputType := JobQueueEntry."Report Output Type"; ObjectTypeToRun := JobQueueEntry."Object Type to Run"; ObjectIdToRun := JobQueueEntry."Object ID to Run"; JobQueueEntry.SetRange("Object Type to Run", ObjectTypeToRun); JobQueueEntry.SetRange("Object ID to Run", ObjectIdToRun); if NoOfMinutesBetweenRuns <> 0 then RecurringJob := true else RecurringJob := false; JobQueueEntry.SetRange("Recurring Job", RecurringJob); if not JobQueueEntry.IsEmpty() then exit; JobQueueEntry.Init(); JobQueueEntry.Validate("Object Type to Run", ObjectTypeToRun); JobQueueEntry.Validate("Object ID to Run", ObjectIdToRun); JobQueueEntry."Earliest Start Date/Time" := CurrentDateTime; if NoOfMinutesBetweenRuns <> 0 then begin JobQueueEntry.Validate("Run on Mondays", true); JobQueueEntry.Validate("Run on Tuesdays", true); JobQueueEntry.Validate("Run on Wednesdays", true); JobQueueEntry.Validate("Run on Thursdays", true); JobQueueEntry.Validate("Run on Fridays", true); JobQueueEntry.Validate("Run on Saturdays", true); JobQueueEntry.Validate("Run on Sundays", true); JobQueueEntry.Validate("Recurring Job", RecurringJob); JobQueueEntry."No. of Minutes between Runs" := NoOfMinutesBetweenRuns; end; JobQueueEntry."Maximum No. of Attempts to Run" := 3; JobQueueEntry."Notify On Success" := true; JobQueueEntry.Status := JobQueueEntry.Status::"On Hold"; JobQueueEntry."Earliest Start Date/Time" := EarliestStartDateTime; JobQueueEntry."Report Output Type" := ReportOutputType; JobQueueEntry.Insert(true); end; procedure DeleteJobQueueEntries(ObjectTypeToDelete: Option; ObjectIdToDelete: Integer) var JobQueueEntry: Record "Job Queue Entry"; begin JobQueueEntry.SetRange("Object Type to Run", ObjectTypeToDelete); JobQueueEntry.SetRange("Object ID to Run", ObjectIdToDelete); if JobQueueEntry.FindSet() then repeat if JobQueueEntry.Status = JobQueueEntry.Status::"In Process" then begin // Non-recurring jobs will be auto-deleted after execution has completed. JobQueueEntry."Recurring Job" := false; JobQueueEntry.Modify(); end else JobQueueEntry.Delete(); until JobQueueEntry.Next() = 0; end; procedure StartInactiveJobQueueEntries(ObjectTypeToStart: Option; ObjectIdToStart: Integer) var JobQueueEntry: Record "Job Queue Entry"; begin JobQueueEntry.SetRange("Object Type to Run", ObjectTypeToStart); JobQueueEntry.SetRange("Object ID to Run", ObjectIdToStart); JobQueueEntry.SetRange(Status, JobQueueEntry.Status::"On Hold"); if JobQueueEntry.FindSet() then repeat JobQueueEntry.SetStatus(JobQueueEntry.Status::Ready); until JobQueueEntry.Next() = 0; end; procedure SetJobQueueEntriesOnHold(ObjectTypeToSetOnHold: Option; ObjectIdToSetOnHold: Integer) var JobQueueEntry: Record "Job Queue Entry"; begin JobQueueEntry.SetRange("Object Type to Run", ObjectTypeToSetOnHold); JobQueueEntry.SetRange("Object ID to Run", ObjectIdToSetOnHold); if JobQueueEntry.FindSet() then repeat JobQueueEntry.SetStatus(JobQueueEntry.Status::"On Hold"); until JobQueueEntry.Next() = 0; end; procedure SetRecurringJobsOnHold(CompanyName: Text) var JobQueueEntry: Record "Job Queue Entry"; begin JobQueueEntry.ChangeCompany(CompanyName); JobQueueEntry.SetRange("Recurring Job", true); JobQueueEntry.SetRange(Status, JobQueueEntry.Status::Ready); if JobQueueEntry.FindSet(true) then repeat JobQueueEntry.Status := JobQueueEntry.Status::"On Hold"; JobQueueEntry.Modify(); until JobQueueEntry.Next() = 0; end; procedure SetStatusToOnHoldIfInstanceInactiveFor(PeriodType: Option Day,Week,Month,Quarter,Year; NoOfPeriods: Integer; ObjectTypeToSetOnHold: Option; ObjectIdToSetOnHold: Integer): Boolean var UserLoginTimeTracker: Codeunit "User Login Time Tracker"; PeriodFirstLetter: Text; FromDate: Date; begin PeriodFirstLetter := CopyStr(Format(PeriodType, 0, 0), 1, 1); FromDate := CalcDate(StrSubstNo('<-%1%2>', NoOfPeriods, PeriodFirstLetter)); if not UserLoginTimeTracker.AnyUserLoggedInSinceDate(FromDate) then begin SetJobQueueEntriesOnHold(ObjectTypeToSetOnHold, ObjectIdToSetOnHold); exit(true); end; exit(false); end; procedure RunJobQueueEntryOnce(var SelectedJobQueueEntry: Record "Job Queue Entry") var JobQueueEntry: Record "Job Queue Entry"; JobQueueLogEntry: Record "Job Queue Log Entry"; SuccessDispatcher: Boolean; SuccessErrorHandler: Boolean; Window: Dialog; CurrentLanguage: Integer; Dimensions: Dictionary of [Text, Text]; begin if not Confirm(RunOnceQst, false) then exit; Window.Open(ExecuteBeginMsg); SelectedJobQueueEntry.CalcFields(XML); JobQueueEntry := SelectedJobQueueEntry; JobQueueEntry.ID := CreateGuid(); JobQueueEntry."User ID" := copystr(UserId(), 1, MaxStrLen(JobQueueEntry."User ID")); JobQueueEntry."Recurring Job" := false; JobQueueEntry.Status := JobQueueEntry.Status::"Ready"; JobQueueEntry."Job Queue Category Code" := ''; JobQueueEntry."Starting Time" := 0T; JobQueueEntry."Ending Time" := 0T; clear(JobQueueEntry."Expiration Date/Time"); clear(JobQueueEntry."System Task ID"); JobQueueEntry.Insert(true); OnRunJobQueueEntryOnceOnAfterJobQueueEntryInsert(SelectedJobQueueEntry, JobQueueEntry); Commit(); CurrentLanguage := GlobalLanguage(); GlobalLanguage(1033); JobQueueTelemetry.SetJobQueueTelemetryDimensions(JobQueueEntry, Dimensions); Session.LogMessage('0000FMG', RunJobQueueOnceTxt, Verbosity::Normal, DataClassification::OrganizationIdentifiableInformation, TelemetryScope::All, Dimensions); GlobalLanguage(CurrentLanguage); // Run the job queue SuccessDispatcher := Codeunit.run(Codeunit::"Job Queue Dispatcher", JobQueueEntry); // If JQ fails, run the error handler if not SuccessDispatcher then begin SuccessErrorHandler := Codeunit.run(Codeunit::"Job Queue Error Handler", JobQueueEntry); // If the error handler fails, save the error (Non-AL errors will automatically surface to end-user) // If it is unable to save the error (No permission etc), it should also just be surfaced to the end-user. if not SuccessErrorHandler then begin JobQueueEntry.SetError(GetLastErrorText()); JobQueueEntry.InsertLogEntry(JobQueueLogEntry); JobQueueEntry.FinalizeLogEntry(JobQueueLogEntry, GetLastErrorCallStack()); Commit(); end; end; Window.Close(); if JobQueueEntry.Find() then if JobQueueEntry.Delete() then; JobQueueLogEntry.SetRange(ID, JobQueueEntry.ID); if JobQueueLogEntry.FindFirst() then if JobQueueLogEntry.Status = JobQueueLogEntry.Status::Success then Message(ExecuteEndSuccessMsg, JobQueueLogEntry.Status) else Message(ExecuteEndErrorMsg, JobQueueLogEntry.Status, JobQueueLogEntry."Error Message"); end; procedure CheckAndRefreshCategoryRecoveryTasks() var JobQueueEntry: Record "Job Queue Entry"; JobQueueCategory: Record "Job Queue Category"; Categories: List of [Code[10]]; Category: Code[10]; begin if not JobQueueEntry.WritePermission() then exit; if not JobQueueCategory.WritePermission() then exit; JobQueueEntry.ReadIsolation(IsolationLevel::ReadUnCommitted); JobQueueEntry.SetFilter("Job Queue Category Code", '<>'''''); JobQueueEntry.SetRange(Status, JobQueueEntry.Status::Waiting); JobQueueEntry.SetLoadFields("Job Queue Category Code"); if not JobQueueEntry.FindSet() then exit; repeat if not Categories.Contains(JobQueueEntry."Job Queue Category Code") then Categories.Add(JobQueueEntry."Job Queue Category Code"); until JobQueueEntry.Next() = 0; JobQueueCategory.ReadIsolation(IsolationLevel::ReadUncommitted); foreach Category in Categories do if JobQueueCategory.Get(Category) then if not IsNullGuid(JobQueueCategory."Recovery Task Id") then if not TaskScheduler.TaskExists(JobQueueCategory."Recovery Task Id") then JobQueueEntry.RefreshRecoveryTask(JobQueueCategory); end; /// <summary> /// To find stale jobs (in process jobs with no scheduled tasks) and set them to error state. /// For both JQE and JQLE /// </summary> [InherentPermissions(PermissionObjectType::TableData, Database::"Job Queue Entry", 'RM')] [InherentPermissions(PermissionObjectType::TableData, Database::"Job Queue Log Entry", 'RM')] procedure FindStaleJobsAndSetError() var JobQueueEntry: Record "Job Queue Entry"; JobQueueLogEntry: Record "Job Queue Log Entry"; JobQueueEntry2: Record "Job Queue Entry"; JobQueueLogEntry2: Record "Job Queue Log Entry"; DidSessionStart: Boolean; DidSessionStop: Boolean; begin // Find all in process job queue entries JobQueueEntry.ReadIsolation(IsolationLevel::ReadUnCommitted); JobQueueEntry.SetLoadFields(ID, "System Task ID", "User Service Instance ID", "User Session ID", Status, "User Session Started"); JobQueueEntry.SetFilter(Status, '%1|%2', JobQueueEntry.Status::Ready, JobQueueEntry.Status::"In Process"); JobQueueEntry.SetRange(Scheduled, false); JobQueueEntry.SetFilter(SystemModifiedAt, '<%1', CurrentDateTime() - GetCheckDelayInMilliseconds()); // Not modified in the last 10 minutes JobQueueEntry2.ReadIsolation(IsolationLevel::UpdLock); if JobQueueEntry.FindSet() then repeat // Check if job is still running or stale // JQE is stale if it has task no longer exists // If stale, set to error if not TaskScheduler.TaskExists(JobQueueEntry."System Task ID") then begin DidSessionStart := SessionStarted(JobQueueEntry."User Service Instance ID", JobQueueEntry."User Session ID", JobQueueEntry."User Session Started"); if DidSessionStart then DidSessionStop := SessionStopped(JobQueueEntry."User Service Instance ID", JobQueueEntry."User Session ID", JobQueueEntry."User Session Started"); if not DidSessionStart or DidSessionStart and DidSessionStop then begin JobQueueEntry2.Get(JobQueueEntry.ID); JobQueueEntry2.SetError(JobSomethingWentWrongMsg); OnFindStaleJobsAndSetErrorOnAfterSetError(JobQueueEntry2); StaleJobQueueEntryTelemetry(JobQueueEntry2); end; end; until JobQueueEntry.Next() = 0; // Find all in process job queue log entries JobQueueLogEntry.ReadIsolation(IsolationLevel::ReadUnCommitted); JobQueueLogEntry.SetLoadFields("Entry No.", ID); JobQueueLogEntry.SetRange(Status, JobQueueLogEntry.Status::"In Process"); JobQueueLogEntry.SetFilter(SystemModifiedAt, '<%1', CurrentDateTime() - GetCheckDelayInMilliseconds()); // Not modified in the last 10 minutes JobQueueLogEntry2.ReadIsolation(IsolationLevel::UpdLock); JobQueueEntry.SetAutoCalcFields(Scheduled); JobQueueEntry.SetLoadFields(ID, Status, Scheduled); if JobQueueLogEntry.FindSet() then repeat if not JobQueueEntry.Get(JobQueueLogEntry.ID) or (JobQueueEntry.Status = JobQueueEntry.Status::Error) or not JobQueueEntry.Scheduled then begin JobQueueLogEntry2.Get(JobQueueLogEntry."Entry No."); JobQueueLogEntry2.Status := JobQueueLogEntry2.Status::Error; JobQueueLogEntry2."Error Message" := JobSomethingWentWrongMsg; if JobQueueLogEntry2."End Date/Time" = 0DT then JobQueueLogEntry2."End Date/Time" := JobQueueLogEntry2."Start Date/Time"; JobQueueLogEntry2.Modify(); StaleJobQueueLogEntryTelemetry(JobQueueLogEntry2); end; until JobQueueLogEntry.Next() = 0; end; [InherentPermissions(PermissionObjectType::TableData, Database::"Job Queue Log Entry", 'RM')] internal procedure UpdateRetriableFailedJobQueueLogEntry(var JobQueueEntry: Record "Job Queue Entry") var JobQueueLogEntry: Record "Job Queue Log Entry"; begin JobQueueLogEntry.SetRange(ID, JobQueueEntry.ID); JobQueueLogEntry.SetRange(Status, JobQueueLogEntry.Status::"In Process"); JobQueueLogEntry.SetFilter("User Service Instance ID", '<>%1', JobQueueEntry."User Service Instance ID"); JobQueueLogEntry.SetFilter("User Session ID", '<>%1', JobQueueEntry."User Session ID"); if not JobQueueLogEntry.FindSet() then exit; repeat JobQueueLogEntry.Status := JobQueueLogEntry.Status::Error; JobQueueLogEntry."Error Message" := CopyStr(JobSomethingWentWrongMsgErr, 1, MaxStrLen(JobQueueLogEntry."Error Message")); JobQueueLogEntry.Modify(); StaleRetriableJobQueueLogEntryTelemetry(JobQueueLogEntry); until JobQueueLogEntry.Next() = 0; Commit(); end; local procedure GetCheckDelayInMilliseconds(): Integer var DelayInMinutes: Integer; begin DelayInMinutes := 10; OnGetCheckDelayInMinutes(DelayInMinutes); if DelayInMinutes < 0 then DelayInMinutes := 0; exit(1000 * 60 * DelayInMinutes); // 10 minutes end; local procedure SessionStarted(ServerInstanceID: Integer; SessionID: Integer; AfterDateTime: DateTime): Boolean var SessionEvent: Record "Session Event"; begin exit(SessionExists(ServerInstanceID, SessionID, AfterDateTime, SessionEvent."Event Type"::Logon)); end; local procedure SessionStopped(ServerInstanceID: Integer; SessionID: Integer; AfterDateTime: DateTime): Boolean var SessionEvent: Record "Session Event"; begin exit(SessionExists(ServerInstanceID, SessionID, AfterDateTime, SessionEvent."Event Type"::Logoff)); end; local procedure SessionExists(ServerInstanceID: Integer; SessionID: Integer; AfterDateTime: DateTime; EventType: Option): Boolean var SessionEvent: Record "Session Event"; begin if AfterDateTime = 0DT then AfterDateTime := CurrentDateTime - 24 * 60 * 60 * 1000; // 24hrs ago SessionEvent.SetRange("Server Instance ID", ServerInstanceID); SessionEvent.SetRange("Session ID", SessionID); SessionEvent.SetFilter("Event Datetime", '>%1', AfterDateTime - 600000); // because session id's start from 1 after server restart SessionEvent.SetRange("Event Type", EventType); exit(not SessionEvent.IsEmpty()); end; local procedure StaleJobQueueEntryTelemetry(JobQueueEntry: Record "Job Queue Entry") var CurrentLanguage: Integer; Dimensions: Dictionary of [Text, Text]; begin CurrentLanguage := GlobalLanguage(); GlobalLanguage(1033); JobQueueTelemetry.SetJobQueueTelemetryDimensions(JobQueueEntry, Dimensions); Session.LogMessage('0000FMH', TelemetryStaleJobQueueEntryTxt, Verbosity::Warning, DataClassification::OrganizationIdentifiableInformation, TelemetryScope::ExtensionPublisher, Dimensions); GlobalLanguage(CurrentLanguage); end; local procedure StaleJobQueueLogEntryTelemetry(JobQueueLogEntry: Record "Job Queue Log Entry") var CurrentLanguage: Integer; Dimensions: Dictionary of [Text, Text]; begin CurrentLanguage := GlobalLanguage(); GlobalLanguage(1033); JobQueueTelemetry.SetJobQueueTelemetryDimensions(JobQueueLogEntry, Dimensions); Session.LogMessage('0000FMI', TelemetryStaleJobQueueLogEntryTxt, Verbosity::Warning, DataClassification::OrganizationIdentifiableInformation, TelemetryScope::ExtensionPublisher, Dimensions); GlobalLanguage(CurrentLanguage); end; local procedure StaleRetriableJobQueueLogEntryTelemetry(JobQueueLogEntry: Record "Job Queue Log Entry") var CurrentLanguage: Integer; Dimensions: Dictionary of [Text, Text]; begin CurrentLanguage := GlobalLanguage(); GlobalLanguage(1033); JobQueueTelemetry.SetJobQueueTelemetryDimensions(JobQueueLogEntry, Dimensions); Session.LogMessage('0000PCR', TelemetryStaleRetriableJobQueueLogEntryTxt, Verbosity::Normal, DataClassification::OrganizationIdentifiableInformation, TelemetryScope::ExtensionPublisher, Dimensions); GlobalLanguage(CurrentLanguage); end; internal procedure TooManyScheduledTasksNotification() var ScheduledTaskNotification: Notification; NoOfScheduledTasks: Integer; begin NoOfScheduledTasks := GetNumberOfScheduledTasks(); if NoOfScheduledTasks >= 100000 then begin ScheduledTaskNotification.Id := TooManyScheduledTasksNotificationGuidLbl; ScheduledTaskNotification.Message := TooManyScheduledTasksNotificationMsg; ScheduledTaskNotification.Scope := NOTIFICATIONSCOPE::LocalScope; ScheduledTaskNotification.AddAction( TooManyScheduledTasksLinkTxt, CODEUNIT::"Job Queue Management", 'TooManyScheduledTasksDocs'); ScheduledTaskNotification.Send(); end; end; internal procedure GetScheduledTasks(): Integer begin exit(GetNumberOfScheduledTasks()) end; internal procedure GetScheduledTasksForUser(UserId: Guid): Integer begin exit(GetNumberOfScheduledTasksForUser(UserId)) end; internal procedure TooManyScheduledTasksDocs(ScheduledTaskNotification: Notification) begin Hyperlink('https://aka.ms/JobQueueDocs'); end; local procedure GetNumberOfScheduledTasksForUser(UserId: Guid): Integer var ScheduledTasks: Record "Scheduled Task"; begin if ScheduledTasks.ReadPermission() then begin ScheduledTasks.SetRange("Is Ready", true); ScheduledTasks.SetRange("User ID", UserId); exit(ScheduledTasks.Count()); end; exit(0); end; local procedure GetNumberOfScheduledTasks(): Integer var ScheduledTasks: Record "Scheduled Task"; begin if ScheduledTasks.ReadPermission() then begin ScheduledTasks.SetRange("Is Ready", true); exit(ScheduledTasks.Count()); end; exit(0); end; local procedure DeleteErrorMessageRegister(RegisterId: Guid) var ErrorMessageRegister: Record "Error Message Register"; begin if IsNullGuid(RegisterId) then exit; ErrorMessageRegister.SetRange(ID, RegisterId); ErrorMessageRegister.DeleteAll(true); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Reporting Triggers", 'ScheduleReport', '', false, false)] local procedure ScheduleReport(ReportId: Integer; RequestPageXml: Text; var Scheduled: Boolean) var ScheduleAReport: Page "Schedule a Report"; begin Scheduled := ScheduleAReport.ScheduleAReport(ReportId, RequestPageXml); end; [EventSubscriber(ObjectType::Table, Database::"Job Queue Entry", 'OnAfterModifyEvent', '', false, false)] local procedure OnStatusChanged(Rec: Record "Job Queue Entry"; xRec: Record "Job Queue Entry"; RunTrigger: Boolean) var CurrentLanguage: Integer; Dimensions: Dictionary of [Text, Text]; begin if Rec.IsTemporary() then exit; if Rec.Status = xRec.Status then exit; CurrentLanguage := GlobalLanguage(); GlobalLanguage(1033); JobQueueTelemetry.SetJobQueueTelemetryDimensions(Rec, Dimensions); Dimensions.Add('JobQueueOldStatus', Format(xRec.Status)); Session.LogMessage('0000FNM', JobQueueStatusChangeTxt, Verbosity::Normal, DataClassification::OrganizationIdentifiableInformation, TelemetryScope::ExtensionPublisher, Dimensions); GlobalLanguage(CurrentLanguage); if Rec."Error Message Register Id" <> xRec."Error Message Register Id" then DeleteErrorMessageRegister(xRec."Error Message Register Id"); end; [EventSubscriber(ObjectType::Table, Database::"Job Queue Entry", 'OnBeforeDeleteEvent', '', false, false)] local procedure OnBeforeDeleteJobQueueEntry(var Rec: Record "Job Queue Entry"; RunTrigger: Boolean) var JobQueueLogEntry: Record "Job Queue Log Entry"; begin if IsNullGuid(Rec."Error Message Register Id") then exit; JobQueueLogEntry.SetRange("Error Message Register Id", Rec."Error Message Register Id"); if JobQueueLogEntry.IsEmpty() then DeleteErrorMessageRegister(Rec."Error Message Register Id"); end; [EventSubscriber(ObjectType::Table, Database::"Job Queue Log Entry", 'OnBeforeDeleteEvent', '', false, false)] local procedure OnBeforeDeleteJobQueueLogEntry(var Rec: Record "Job Queue Log Entry"; RunTrigger: Boolean) var JobQueueEntry: Record "Job Queue Entry"; begin if IsNullGuid(Rec."Error Message Register Id") then exit; JobQueueEntry.SetRange("Error Message Register Id", Rec."Error Message Register Id"); if JobQueueEntry.IsEmpty() then DeleteErrorMessageRegister(Rec."Error Message Register Id"); end; /// <Summary>Used for test. Sets the minimum age of stale job queue entries and job queue log entries.</Summary> /// <Parameters>DelayInMinutes defaults to 10 minutes but can be overridden to a longer or shorter time, including 0</Parameters> [IntegrationEvent(false, false)] local procedure OnGetCheckDelayInMinutes(var DelayInMinutes: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnRunJobQueueEntryOnceOnAfterJobQueueEntryInsert(SelectedJobQueueEntry: Record "Job Queue Entry"; JobQueueEntry: Record "Job Queue Entry") begin end; [IntegrationEvent(false, false)] local procedure OnFindStaleJobsAndSetErrorOnAfterSetError(var JobQueueEntry: Record "Job Queue Entry") begin end;}