| Subject: | SQL Process Scheduler should run the longest waiting job first |
| Summary: | When the SQL Scheduler picks up jobs to run, we should run the "Oldest Waiting Job" first |
| Audit Notes: | Edited by sanjay on 22/09/23 16:20. Edited by sanjay on 22/09/23 15:07. |
| 21 Sep 2023 | 02:32PM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 29-09-2023 02:30 PM Time Taken: 6.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 15.00 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - When getting the list of processes to run, we order the list by the "Next Run Date" to get the longest waiting task on the top of the list
3. Affected Areas: - SQL Process Order
4. The issue was caused by: - Improvement
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
| 22 Sep 2023 | 03:35PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 29-09-2023 03:34 PM Time Taken: 6.00 |
|
The following tests were performed:
Table 1 - Test Results
| No | Test Case | Expected Result | Pass/Fail | Comments | | 1 | Review the list of processes to execute (across Multiple Companies) and ensure that the older process gets the highest priority
|
| Pass
|
|
Environment Details - OS version: Win11
- Application version: 14.
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|
| 22 Sep 2023 | 04:44PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 29-09-2023 04:42 PM Time Taken: 4.00 Notes: ETC extended from: 21/09/2023 to 29/09/2023 |
| ** Need to change SQL Process Execute method to ignore "Data Returns" from Processes Scripts. This is causing a "result" error in the logs which is unnecessary. I have created a new function to Execute SQL Commands. "UtilityDAL.ExecuteSQLCommand" - Testing Required. |
|
| 26 Sep 2023 | 04:44PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-10-2023 04:42 PM Time Taken: 2.00 |
|
The following tests were performed:
Table 1 - Test Results
| No | Test Case | Expected Result | Pass/Fail | Comments | | 1 | Enable multiple processes in different companies
| Each process should run based on the longest waiting one running first
| Pass
|
|
Environment Details - OS version: Win11
- Application version: 15.00
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|