.Net Framework 4.8
v480.1000 (2/6/2025)
- Allow for Parallel processing of jobs. User must set .config file setting RunParallel = "true", when this mode is enabled the following will occur:
- sri_job_queue.ACTIVE_STATUS will set to "IP" (In Progress) when being executed, revert back to "GO" if there is a retry.
- SQL Server any query will be run in ASYNC mode
- Macros will run on their own thread
- .exe files no change
.Net Framework 4.6.2
v462.1002 (1/8/2025)
- Microsoft UserInteractive method is causing issues on some servers. Remove the use of this x86 legacy component and add a .config key "Interactive" to be used to place code into Interactive mode (manually run from console).
v462.1001
- Update to Flush Buffering Appenders; Add AppContextSwitchOverrides for TLS 1.2
v462.1000
- Update to run in .NET Framework 4.6.2 with Connected Services *Requires SRI Macro Server v1000.1000*
- "Optimize SRI_JOB_QUEUE SQL Indexes
- Move COMPLETE_DATETIME to first Column
- IX_Dequeue: Add JOB_ID Column for ORDER BY tie break"
- Optimize SRI_JOBSUBMIT SQL Performance (Refactor out upfront EXISTS check)
v450.1006
- Update ProcessMacroScriptJob to Wrap in Double Quotes (if spaces) & Set Engine to VBScript
v450.1005
- Enhance Timed Out Errors, Properly Escape Quotes with No Spaces, Handle Timed Out Check & Enhance Logging in ProcessExecutable()
v450.1004
- Support Spaces in ProcessExecutable() with Quotes
v450.1003
- Run: Fire Process Event Now in separate Thread so Window Service responses cleanly when Started
- Resolve MSBuild not honoring Prefer32Bit when PlatformTarget not explicitly defined as AnyCPU
- Add README.txt for 32-bit(x86) Install Instructions (Note: Assembly must be same name to pass legacy SRI Macro Server Licensing Check)
v450.1002
- Add 32-bit (x86) build with Prefer 32-bit compile flags & Add better exception if Creds Key not found
- Fix loading log4net.dll.config when running as Service
v450.1001
- Update log4net to log separate files per Server Instance DB & set Application Name=Synergy Job Queue for SQL Server Connection strings
v450.1000
- Major Refactor & Upgrade .NET 4.5
- "Removed garbage scripts (backup file in use ~script)
- Rename files to include installation order
- Refactored code to insert using a Sequence
- Added Index to support the job lookup query"
- "Modifications to Database Table Installer
- --BAT File configuration for proper logging
- --Cleanup of SqlServer installer / files"
- This is a very active project
- "Source cleanup / add missing projects
- manual merge differences in code as necessary
- Remove assemblyinfo.cs from all projects except the queue engine (all other projects will use engine assembly info as linked file)
- Add references folder (for log4net & VTGMacroServerInterface.dll)
- Add post build commands so releasekit folder is created for all projects (except SqlBase)"
- Update debugging, got it to build (for Royal).
- Add Retry logic to Load, LoadQueue, and Execute as in Save.
- Handle "deadlock victim" and other SQL errors gracefully.
- Queue engine now looks for status of "Go" to Execute queued job
"Build 4225
*********Enhancements: (not tested)*************
New Job Type: EX - Designed to Run EXE without blocking
New Job Type: EB - Designed to Run EXE WITH blocking
Added Worker.ProcessExecutable methods
- UnTested, intended to run external process with new Job type
************************************************
*********Enhancements: ************************
New Command Argument /P 0 or 1 Enable Performance Monitor
Re-factored JobQueuePerformanceCounter eliminating Static Methods (and constructor) to work with the Conditional Enable per instance.
************************************************
Refactored Command / Help options Uses Windows Forms Messagebox"