.Net Framework 4.8
2025.02.06 v480.1000
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
2025.01.08 v462.1002
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"