Table 472 Job Queue Entry in 18
- App
- Base Application
Fields, 53Keys, 5Procedures, 53Events, 13
Versions171819202122232425262728latest
Source29
Fields, 53
| Id | Name | Type | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| 1 | ID | Guid | - | ||||
| 2 | User ID | Text[65] | - | ||||
| 3 | XML | Blob | - | ||||
| 4 | Last Ready State | DateTime | - | ||||
| 5 | Expiration Date/Time | DateTime | - | ||||
| 6 | Earliest Start Date/Time | DateTime | - | ||||
| 7 | Object Type to Run | Option | - | ||||
| 8 | Object ID to Run | Integer | - | ||||
| 9 | Object Caption to Run | Text[250] | - | ||||
| 10 | Report Output Type | Option | - | ||||
| 11 | Maximum No. of Attempts to Run | Integer | - | ||||
| 12 | No. of Attempts to Run | Integer | - | ||||
| 13 | Status | Option | - | ||||
| 14 | Priority | Integer | Removed 15.0 | ||||
| No longer supported. | |||||||
| 15 | Record ID to Process | RecordId | - | ||||
| 16 | Parameter String | Text[250] | - | ||||
| 17 | Recurring Job | Boolean | - | ||||
| 18 | No. of Minutes between Runs | Integer | - | ||||
| 19 | Run on Mondays | Boolean | - | ||||
| 20 | Run on Tuesdays | Boolean | - | ||||
| 21 | Run on Wednesdays | Boolean | - | ||||
| 22 | Run on Thursdays | Boolean | - | ||||
| 23 | Run on Fridays | Boolean | - | ||||
| 24 | Run on Saturdays | Boolean | - | ||||
| 25 | Run on Sundays | Boolean | - | ||||
| 26 | Starting Time | Time | - | ||||
| 27 | Ending Time | Time | - | ||||
| 28 | Reference Starting Time | DateTime | - | ||||
| 29 | Next Run Date Formula | DateFormula | - | ||||
| 30 | Description | Text[250] | - | ||||
| 31 | Run in User Session | Boolean | - | ||||
| 32 | User Session ID | Integer | - | ||||
| 33 | Job Queue Category Code | Code[10] | - | ||||
| 34 | Error Message | Text[2048] | - | ||||
| 35 | Error Message 2 | Text[250] | Removed 15.0 | ||||
| Error Message field size has been increased. | |||||||
| 36 | Error Message 3 | Text[250] | Removed 15.0 | ||||
| Error Message field size has been increased. | |||||||
| 37 | Error Message 4 | Text[250] | Removed 15.0 | ||||
| Error Message field size has been increased. | |||||||
| 40 | User Service Instance ID | Integer | - | ||||
| 41 | User Session Started | DateTime | - | ||||
| 42 | Timeout (sec.) | Integer | Removed 15.0 | ||||
| No longer supported. | |||||||
| 43 | Notify On Success | Boolean | - | ||||
| 44 | User Language ID | Integer | - | ||||
| 45 | Printer Name | Text[250] | - | ||||
| 46 | Report Request Page Options | Boolean | - | ||||
| 47 | Rerun Delay (sec.) | Integer | - | ||||
| 48 | System Task ID | Guid | - | ||||
| 49 | Scheduled | Boolean | - | ||||
| 50 | Manual Recurrence | Boolean | - | ||||
| 51 | On Hold Due to Inactivity | Boolean | Removed 18.0 | ||||
| Functionality moved into new job queue status | |||||||
| 52 | Inactivity Timeout Period | Integer | - | ||||
| 53 | Error Message Register Id | Guid | - | ||||
| 54 | Job Timeout | Duration | - | ||||
| 55 | Recovery Task Id | Guid | - | ||||
Keys, 5
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | ID | - |
| Key2 | Job Queue Category Code | - |
| Key3 | Last Ready State | - |
| Key4 | Recurring Job | - |
| Key5 | System Task ID | - |
Procedures, 53
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| DoesExistLocked | () | Boolean | public | - | |||
| RefreshLocked | () | public | - | ||||
| IsExpired | (DateTime) | Boolean | public | - | |||
| IsReadyToStart | () | Boolean | public | - | |||
| ShowErrorMessage | () | public | - | ||||
| SetError | (Text) | public | - | ||||
| SetResult | (Boolean, Option, Guid) | public | - | ||||
| SetResultDeletedEntry | () | public | - | ||||
| FinalizeRun | () | public | - | ||||
| GetLastLogEntryNo | () | Integer | public | - | |||
| InsertLogEntry | (var Record Job Queue Log Entry) | public | - | ||||
| FinalizeLogEntry | (Record Job Queue Log Entry) | public | - | ||||
| FinalizeLogEntry | (Record Job Queue Log Entry, Text) | public | - | ||||
| SetStatus | (Option) | public | - | ||||
| Cancel | () | public | - | ||||
| DeleteTask | () | public | - | ||||
| DeleteTasks | () | public | - | ||||
| Restart | () | public | - | ||||
| TryCheckRequiredPermissions | () | Boolean | internal | - | |||
| CancelTask | () | public | - | ||||
| ScheduleTask | () | Guid | public | - | |||
| ReuseExistingJobFromID | (Guid, DateTime) | Boolean | public | - | |||
| ReuseExistingJobFromCatagory | (Code[10], DateTime) | Boolean | public | - | |||
| IsNextRunDateFormulaSet | () | Boolean | public | - | |||
| ShowStatusMsg | (Guid) | public | - | ||||
| LookupRecordToProcess | () | public | - | ||||
| LookupObjectID | (var Integer) | Boolean | public | - | |||
| GetXmlContent | () | Text | public | - | |||
| SetXmlContent | (Text) | public | - | ||||
| GetReportParameters | () | Text | public | - | |||
| SetReportParameters | (Text) | public | - | ||||
| RunReportRequestPage | () | public | - | ||||
| ScheduleJobQueueEntry | (Integer, RecordId) | public | - | ||||
| ScheduleJobQueueEntryWithParameters | (Integer, RecordId, Text[250]) | public | - | ||||
| ScheduleJobQueueEntryForLater | (Integer, DateTime, Code[10], Text) | public | - | ||||
| GetStartingDateTime | (DateTime) | DateTime | public | - | |||
| GetEndingDateTime | (DateTime) | DateTime | public | - | |||
| ScheduleRecurrentJobQueueEntry | (Option, Integer, RecordId) | public | - | ||||
| ScheduleRecurrentJobQueueEntryWtihFrequency | (Option, Integer, RecordId, Integer) | public | Pending 17.0 | ||||
| Replaced by ScheduleRecurrentJobQueueEntryWithFrequency to fix typo in the name | |||||||
| ScheduleRecurrentJobQueueEntryWtihFrequency | (Option, Integer, RecordId, Integer, Integer, Integer) | public | Pending 17.0 | ||||
| Replaced by ScheduleRecurrentJobQueueEntryWithFrequency to fix typo in the name | |||||||
| ScheduleRecurrentJobQueueEntryWithFrequency | (Option, Integer, RecordId, Integer) | public | - | ||||
| ScheduleRecurrentJobQueueEntryWithFrequency | (Option, Integer, RecordId, Integer, Time) | public | - | ||||
| ScheduleRecurrentJobQueueEntryWithFrequency | (Option, Integer, RecordId, Integer, Integer, Integer, Time) | internal | - | ||||
| ScheduleRecurrentJobQueueEntryWithRunDateFormula | (Option, Integer, RecordId, Code[10], Integer, DateFormula, Time) | internal | - | ||||
| InitRecurringJob | (Integer) | public | - | ||||
| FindJobQueueEntry | (Option, Integer) | Boolean | public | - | |||
| GetDefaultDescription | () | Text[250] | public | - | |||
| IsToReportInbox | () | Boolean | public | - | |||
| FilterInactiveOnHoldEntries | () | public | - | ||||
| DoesJobNeedToBeRun | () | Boolean | public | - | |||
| CheckRequiredPermissions | () | internal | - | ||||
| DefaultJobTimeout | () | Duration | public | - | |||
| ScheduleRecoveryJob | () | public | - | ||||
Events, 13
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterReschedule | (var Record Job Queue Entry) | - |
| Integration event | OnAfterSetDefaultValues | (var Record Job Queue Entry) | - |
| Integration event | OnBeforeClearServiceValues | (var Record Job Queue Entry) | - |
| Integration event | OnAfterFinalizeRun | (Record Job Queue Entry) | - |
| Integration event | OnBeforeInsertLogEntry | (var Record Job Queue Log Entry, var Record Job Queue Entry) | - |
| Integration event | OnBeforeModifyLogEntry | (var Record Job Queue Log Entry, var Record Job Queue Entry) | - |
| Integration event | OnBeforeScheduleTask | (var Record Job Queue Entry, var Guid, var Boolean) | - |
| Integration event | OnBeforeSetStatusValue | (var Record Job Queue Entry, var Record Job Queue Entry, var Option) | - |
| Integration event | OnBeforeTryRunJobQueueSendNotification | (var Record Job Queue Entry, var Boolean) | - |
| Integration event | OnFindingIfJobNeedsToBeRun | (var Boolean) | - |
| Integration event | OnInsertOnBeforeSetDefaultValues | (var Record Job Queue Entry, var Boolean) | - |
| Integration event | OnBeforeScheduleRecoveryJob | (var Record Job Queue Entry, var Duration) | - |
| Internal event | OnReuseExisingJobFromId | (var Record Job Queue Entry) | - |