KBI 311296 Issue Addressed Argent for SQL Server Send Out False Alert While Executing SQL Job Rule Against SQL Server 2005


Argent Advanced Technology 3.1A-1507-A or earlier


Thursday, 8 October 2015


An issue has been addressed that Argent for SQL Server failed to execute SQL Job Rule against SQL Server 2005

Technical Background

The SQL Job Rule sends false Alert while executing against SQL Server 2005

The Alert states that ‘SQL Server SMO exception occurred: Execute with results failed for Database ‘master’

Type DATE is not a defined system type’

SQL Job Rule uses an SQL query to get the Job details of target server and one SQL function used in the query was not supported in SQL Server version 2005

This issue is resolved by enhancing the SQL query that is compatible with all SQL Server versions


Upgrade to Argent Advanced Technology 3.1A-1510-A or later