KBI 311296 Issue Addressed Argent for SQL Server Send Out False Alert While Executing SQL Job Rule Against SQL Server 2005
Version
Argent Advanced Technology 3.1A-1507-A or earlier
Date
Thursday, 8 October 2015
Summary
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
Resolution
Upgrade to Argent Advanced Technology 3.1A-1510-A or later