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