KBI 310763 Issue Addressed: Error Message Shows SQL Query Failed To Add Column Purge_Old_Adhoc_Instance When Upgrading Argent Job Scheduler
Version
Argent Job Scheduler 1306-A or below
Date
Wednesday, 27 Nov 2013
Summary
Addressed the issue of getting the error message ‘SQL query failed to add column Purge_Old_Adhoc_Instance‘ when upgrading Argent Job Scheduler on Windows 2000 Server
Technical Background
In SQL server 2000 the table ‘sys.columns‘ does not exist
When SQL query searches for the Purge_Old_Adhoc_Instance field in the ‘sys.columns‘, the following error occurs
This issue has been addressed in Argent Job Scheduler 1311-A
Resolution
Upgrade to Argent Job Scheduler 1312-B or above